Oracle Apps Technical Stuff
Tuesday, March 18, 2014
How to Query the Service Contracts Tables for Header, Line, Subline and Billing Information (11.5.10+ ) - 467334.1
›
A. Contract Header Data This SQL takes data from views rather than from actual contracts tables and is useful for reviewing data but no...
Monday, March 17, 2014
How To Write Out Multiple Clob Fields > 32k To A File in 4K chunks? (Doc ID 358781.1)
›
DECLARE l_output UTL_FILE.file_type; l_amt NUMBER DEFAULT 4000; l_offset NUMBER DEFAULT 1; position INTEGER := 1; contado...
Friday, February 21, 2014
Sample Subscription Package used for Business event in Oracle applications.
›
CREATE OR REPLACE PACKAGE xx_delivery_subscription_pkg AS FUNCTION subscription( p_subscription_guid IN RAW ...
Query to get the Menu,Submenu and function details For Oracle Menus
›
SELECT second.application_id "App ID" , second.application_name "App Name" , second.responsibility_id...
2 comments:
‹
›
Home
View web version