APPS.GML_LOG dependencies on CPG_PURCHASING_INTERFACE

Line 32: FROM cpg_purchasing_interface

28: BEGIN
29:
30: /* INSERT INTO cpg_purchasing_arch
31: SELECT *
32: FROM cpg_purchasing_interface
33: WHERE invalid_ind IN ('Y', 'P'); */
34:
35: INSERT INTO cpg_purchasing_arch(
36: TRANSACTION_ID ,

Line 133: FROM cpg_purchasing_interface

129: ORGNADDR_ID ,
130: SOURCE_SHIPMENT_ID ,
131: PURCH_CATEGORY_ID )
132: SELECT *
133: FROM cpg_purchasing_interface
134: WHERE invalid_ind IN ('Y', 'P');
135:
136: DELETE FROM cpg_purchasing_interface
137: WHERE invalid_ind IN ('Y', 'P');

Line 136: DELETE FROM cpg_purchasing_interface

132: SELECT *
133: FROM cpg_purchasing_interface
134: WHERE invalid_ind IN ('Y', 'P');
135:
136: DELETE FROM cpg_purchasing_interface
137: WHERE invalid_ind IN ('Y', 'P');
138:
139: /* Insert rows from cpg_oragems_mapping to cpg_oragems_arch*/
140: