- 博客(15)
- 收藏
- 关注
RSS订阅转载 WIP Useful Scripts .
Query to find WIP Job details[sql] view plaincopyprint?SELECT E.WIP_ENTITY_ID, E.WIP_ENTITY_NAME Job, M.SEGMENT1 ITEM, --M.INVENTORY_ITEM_ID, M.DESCRIPTION Item_Desc, D.DESC
2013-07-09 12:28:26
839
转载 Oracle EBS Advanced Pricing Tables .
TablesQP_LIST_HEADERS_BQP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions.QP_LIST_LINESQP_LIST_LINES sto
2013-07-09 12:25:44
913
转载 Global Variable in PL/SQL .
Non-Across Sessions[sql] view plaincopyprint?create or replace package test_pkg as global_var number :=1; constant_var CONSTANT NUMBER := 2; end; create or replace package t
2013-07-09 12:22:39
402
转载 SQL Query to get Oracle Menus & Functions .
Script that queries the Menu structure[sql] view plaincopyprint?SELECT LPAD (' ', 6 * (LEVEL - 1)) || menu_entry.entry_sequence SEQUENCE, LPAD (' ', 6 * (LEVEL - 1))
2013-07-09 12:22:07
745
转载 PL/SQL Cursor常见用法模板 .
1.Loop[sql] view plaincopyprint?DECLARE emp_rec emp%rowtype; CURSOR emp_cur IS SELECT * FROM emp; BEGIN OPEN emp_cur; LOOP FETCH emp_cur INTO em
2013-07-09 12:16:54
512
转载 Send Emails from PL/SQL .
1.要想从DB Server发邮件，首先得确保DB Server已经启用了SMTP(Simple Mail Transfer Protocol)服务。检查是否启动SMTP的方法telnet server.domain.com 25(25是SMTP的默认端口)2.PL/SQL to send email sample code:[sql] view plaincopy
2013-07-09 12:14:00
524
转载 Script – Database structure and file location .
1.Control Files[sql] view plaincopyprint?set pagesize 500 set linesize 130 Prompt Prompt Control Files Location >>>> col name format a60 heading "Control Files" select name from
2013-07-09 12:12:13
538
转载 Script – Tablespace Information .
SET linesize 150 column tablespace_name format a20 heading 'Tablespace' column sumb format 999,999,999 column extents format 9999 column bytes format 999,999,999,999 column largest format 999,999
2013-07-09 12:11:01
471
转载 Diagnostic Script for Concurrent Requests .
source:REQCHECK.sql - Diagnostic Script for Concurrent Requests (Doc ID 164978.1)This Script is made available for Diagnosing Common Problems Related to Concurrent Requests.[sql] vie
2013-07-09 12:10:06
567
转载 Purchasing Useful Scripts .
Relation between Requisition and PO tables,Here is link:PO_DISTRIBUTIONS_ALL =>PO_HEADER_ID, REQ_DISTRIBUTION_IDPO_HEADERS_ALL=>PO_HEADER_ID, SEGMENT1PO_REQ_DISTRIBUTIONS_ALL =>DISTRIBUTION_ID,
2013-07-09 12:08:53
3119
转载 Sales Order Related Scripts
--Line Ids Associated With This Order NumberSELECT LIN.LINE_ID LINE_ID, TO_CHAR(LIN.line_number) || DECODE(LIN.shipment_number, NULL, NULL, '.' || TO_CHAR(LIN.shipment_number)) || DECODE
2013-07-09 12:04:25
760
转载 How to generate an GL debug log file .
Detail Log for GL programsUsed for concurrent request problems where we need to know what sql was used in key areas or we need to retain temporary tables.Note: Be aware that temp tables are n
2013-07-09 11:52:50
479
转载 How Inventory Passes Journals To General Ledger (GL)
Inventory Transactions transfer to GL normally done by Program called INCTGL.The accounting information related to transactions in INV module is transferred to GL by running the ‘Transfer Transact
2013-07-09 11:49:12
687
转载 Oracle ERP系统借贷关系表 .
一、 采购接收入库和退货： 1.接收： 借：材料采购 （订单价格） 贷：应计负债 （订单价格） 2.入库： 借：原材料 （标准成本） 贷：材料采购 （订单价格） 借或贷：材料成本差异＿材料订单价格 3.退货至接收时产生与上面第2步相反的分录，退货至供货商时产生与上面第1步相反的分录。二、 子库存转移：只有转出子库产生分录
2013-07-09 11:41:21
509
转载 General Ledger Useful SQL Scripts – Oracle Applications 11i
General Ledger Useful SQL Scripts – Oracle Applications 11iContentsGL Set of Books Configuration Overview
2013-07-09 11:38:20
1260
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人