26: SELECT MAX(time_stamp)
27: FROM cpg_oragems_arch;
28: BEGIN
29: 30: /* INSERT INTO cpg_purchasing_arch 31: SELECT *
32: FROM cpg_purchasing_interface
33: WHERE invalid_ind IN ('Y', 'P'); */
34:
Line 35: 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 ,
37: TRANSACTION_TYPE ,
38: ORGN_CODE ,
39: PO_NO ,