APPS.RCV_GML_CONV_MIG dependencies on GML_RCV_LOTS_MIGRATION

Line 84: -- FROM GML_RCV_LOTS_MIGRATION glm

80: -- and rt.organization_id = mp.organization_id
81: -- and mp.process_enabled_flag = 'Y'
82: -- and not exists
83: -- (SELECT /*+ push_subq no_unnest */ 'x'
84: -- FROM GML_RCV_LOTS_MIGRATION glm
85: -- WHERE table_name = 'RCV_LOT_TRANSACTIONS'
86: -- AND glm.source_transaction_id = rlt.source_transaction_id
87: -- AND glm.transaction_id = rlt.transaction_id
88: -- AND glm.correction_transaction_id = rlt.correction_transaction_id);

Line 131: FROM GML_RCV_LOTS_MIGRATION glm

127: AND mlot.lot_number is NOT NULL
128: AND mp.process_enabled_flag = 'Y'
129: AND NOT EXISTS
130: (SELECT /*+ push_subq no_unnest */ 'x'
131: FROM GML_RCV_LOTS_MIGRATION glm
132: WHERE table_name = 'RCV_LOT_TRANSACTIONS'
133: AND glm.source_transaction_id = rlt.source_transaction_id
134: AND glm.transaction_id = rlt.transaction_id
135: AND glm.correction_transaction_id = rlt.correction_transaction_id);

Line 164: (SELECT 'x' from GML_RCV_LOTS_MIGRATION glm

160: and (rlt.sublot_num <> '-1' or rlt.sublot_num IS NULL)
161: and rsl.to_organization_id = mp.organization_id
162: and mp.process_enabled_flag = 'Y'
163: and not exists
164: (SELECT 'x' from GML_RCV_LOTS_MIGRATION glm
165: WHERE table_name = 'RCV_LOT_TRANSACTIONS'
166: And glm.shipment_line_id = rlt.shipment_line_id);
167: */
168:

Line 203: (SELECT 'x' from GML_RCV_LOTS_MIGRATION glm

199: AND rsl.to_organization_id = mp.organization_id
200: AND mlot.lot_number is NOT NULL
201: AND mp.process_enabled_flag = 'Y'
202: AND not exists
203: (SELECT 'x' from GML_RCV_LOTS_MIGRATION glm
204: WHERE table_name = 'RCV_LOT_TRANSACTIONS'
205: And glm.shipment_line_id = rlt.shipment_line_id);
206:
207: l_lot_num VARCHAR2(80);

Line 248: INSERT INTO GML_RCV_LOTS_MIGRATION

244: set LOT_NUM = cr_rec.lot_number
245: where rowid = cr_rec.rowid;
246:
247:
248: INSERT INTO GML_RCV_LOTS_MIGRATION
249: ( TABLE_NAME,
250: TRANSACTION_ID,
251: SOURCE_TRANSACTION_ID,
252: SHIPMENT_LINE_ID,

Line 319: INSERT INTO GML_RCV_LOTS_MIGRATION

315: UPDATE rcv_lot_transactions
316: SET LOT_NUM = cr_rec1.lot_number
317: where rowid = cr_rec1.rowid;
318:
319: INSERT INTO GML_RCV_LOTS_MIGRATION
320: ( TABLE_NAME,
321: TRANSACTION_ID,
322: SOURCE_TRANSACTION_ID,
323: SHIPMENT_LINE_ID,

Line 511: (SELECT 'x' from GML_RCV_LOTS_MIGRATION glm

507: AND rt.shipment_header_id = rsl.shipment_header_id
508: AND rt.shipment_line_id = rsl.shipment_line_id
509: AND mp.process_enabled_flag = 'Y'
510: and not exists
511: (SELECT 'x' from GML_RCV_LOTS_MIGRATION glm
512: WHERE table_name = 'RCV_LOTS_SUPPLY'
513: and glm.transaction_id = rls.transaction_id
514: and glm.shipment_line_id = rls.shipment_line_id)
515: --ignore fulfilled supply rows

Line 552: (SELECT 'x' from GML_RCV_LOTS_MIGRATION glm

548: WHERE rl.supply_type_code = 'SHIPMENT'
549: GROUP BY rl.shipment_line_id,rl.lot_num
550: HAVING SUM(rl.quantity) > 0)
551: /*and not exists
552: (SELECT 'x' from GML_RCV_LOTS_MIGRATION glm
553: WHERE table_name = 'RCV_LOTS_SUPPLY'
554: And glm.shipment_line_id = rls.shipment_line_id)*/
555: ORDER BY rsl.shipment_line_id
556: FOR UPDATE OF LOT_NUM;

Line 602: INSERT INTO GML_RCV_LOTS_MIGRATION

598: SET LOT_NUM = l_lot_num,
599: REASON_ID = l_reason_id
600: WHERE rowid = cr_rec.rowid;
601:
602: INSERT INTO GML_RCV_LOTS_MIGRATION
603: ( TABLE_NAME,
604: TRANSACTION_ID,
605: SOURCE_TRANSACTION_ID,
606: SHIPMENT_LINE_ID,

Line 670: INSERT INTO GML_RCV_LOTS_MIGRATION

666: SET LOT_NUM = l_lot_num,
667: REASON_ID = l_reason_id
668: WHERE rowid = cr_rec1.rowid;
669:
670: INSERT INTO GML_RCV_LOTS_MIGRATION
671: ( TABLE_NAME,
672: TRANSACTION_ID,
673: SOURCE_TRANSACTION_ID,
674: SHIPMENT_LINE_ID,