Oracle Apps Technical Stuff
Thursday, September 8, 2016
API for Expire Instance relationship in Oracle install base
›
PROCEDURE csi_expire_relationship( p_object_id IN NUMBER) IS l_relationship_rec csi_datastructures_pub.ii_re...
API to create Instance relationship in Oracle install Base
›
PROCEDURE csi_create_relationship( p_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl , x_return_status ...
API to Expire Instance in Oracle Install Base
›
DECLARE l_record_status VARCHAR2(1); l_sv_status VARCHAR2(2000); ...
Sunday, September 4, 2016
API to swap Service contract for Newly created Install Base with Old install base
›
DECLARE p_transaction_type VARCHAR2(50); p_instance_id NUMBER; p_new_instance_id NUMBER;...
Tuesday, August 9, 2016
Matrix/Crosstab SQL using PIVOT functionality
›
Sample SQL's Using Decode and aggregate functions. SELECT item , inventory , product_family FROM ( SELECT msi.segmen...
‹
›
Home
View web version