APPS.RCV_GML_CONV_MIG dependencies on GML_RCV_LOTS_MIGRATION

Line 78: FROM GML_RCV_LOTS_MIGRATION glm

74: and rt.organization_id = mp.organization_id
75: and mp.process_enabled_flag = 'Y'
76: and not exists
77: (SELECT 'x'
78: FROM GML_RCV_LOTS_MIGRATION glm
79: WHERE table_name = 'RCV_LOT_TRANSACTIONS'
80: AND glm.source_transaction_id = rlt.source_transaction_id
81: AND glm.transaction_id = rlt.transaction_id
82: AND glm.correction_transaction_id = rlt.correction_transaction_id);

Line 106: (SELECT 'x' from GML_RCV_LOTS_MIGRATION glm

102: and (rlt.sublot_num <> '-1' or rlt.sublot_num IS NULL)
103: and rsl.to_organization_id = mp.organization_id
104: and mp.process_enabled_flag = 'Y'
105: and not exists
106: (SELECT 'x' from GML_RCV_LOTS_MIGRATION glm
107: WHERE table_name = 'RCV_LOT_TRANSACTIONS'
108: And glm.shipment_line_id = rlt.shipment_line_id);
109:
110: l_lot_num VARCHAR2(80);

Line 144: INSERT INTO GML_RCV_LOTS_MIGRATION

140: where rowid = cr_rec.rowid;
141:
142:
143:
144: INSERT INTO GML_RCV_LOTS_MIGRATION
145: ( TABLE_NAME,
146: TRANSACTION_ID,
147: SOURCE_TRANSACTION_ID,
148: SHIPMENT_LINE_ID,

Line 205: INSERT INTO GML_RCV_LOTS_MIGRATION

201: UPDATE rcv_lot_transactions
202: SET LOT_NUM = l_lot_num
203: where rowid = cr_rec1.rowid;
204:
205: INSERT INTO GML_RCV_LOTS_MIGRATION
206: ( TABLE_NAME,
207: TRANSACTION_ID,
208: SOURCE_TRANSACTION_ID,
209: SHIPMENT_LINE_ID,

Line 397: (SELECT 'x' from GML_RCV_LOTS_MIGRATION glm

393: AND rt.shipment_header_id = rsl.shipment_header_id
394: AND rt.shipment_line_id = rsl.shipment_line_id
395: AND mp.process_enabled_flag = 'Y'
396: and not exists
397: (SELECT 'x' from GML_RCV_LOTS_MIGRATION glm
398: WHERE table_name = 'RCV_LOTS_SUPPLY'
399: and glm.transaction_id = rls.transaction_id
400: and glm.shipment_line_id = rls.shipment_line_id)
401: ORDER BY rls.transaction_id;

Line 424: (SELECT 'x' from GML_RCV_LOTS_MIGRATION glm

420: and (rlt.sublot_num <> '-1' or rlt.sublot_num is NULL)
421: AND mp.organization_id = rsl.to_organization_id
422: AND mp.process_enabled_flag = 'Y'
423: /*and not exists
424: (SELECT 'x' from GML_RCV_LOTS_MIGRATION glm
425: WHERE table_name = 'RCV_LOTS_SUPPLY'
426: And glm.shipment_line_id = rls.shipment_line_id)*/
427: ORDER BY rsl.shipment_line_id
428: FOR UPDATE OF LOT_NUM;

Line 474: INSERT INTO GML_RCV_LOTS_MIGRATION

470: SET LOT_NUM = l_lot_num,
471: REASON_ID = l_reason_id
472: WHERE rowid = cr_rec.rowid;
473:
474: INSERT INTO GML_RCV_LOTS_MIGRATION
475: ( TABLE_NAME,
476: TRANSACTION_ID,
477: SOURCE_TRANSACTION_ID,
478: SHIPMENT_LINE_ID,

Line 542: INSERT INTO GML_RCV_LOTS_MIGRATION

538: SET LOT_NUM = l_lot_num,
539: REASON_ID = l_reason_id
540: WHERE rowid = cr_rec1.rowid;
541:
542: INSERT INTO GML_RCV_LOTS_MIGRATION
543: ( TABLE_NAME,
544: TRANSACTION_ID,
545: SOURCE_TRANSACTION_ID,
546: SHIPMENT_LINE_ID,