DBA Data[Home] [Help]

APPS.GMF_MIGRATION dependencies on GMF_LOT_COST_ADJUSTMENT_DTLS

Line 5217: INSERT INTO gmf_lot_cost_adjustment_dtls

5213: BEGIN
5214: /****************************************************************************
5215: * Insert rows for Additional Lots Created as part of Lot Balances Migration *
5216: ****************************************************************************/
5217: INSERT INTO gmf_lot_cost_adjustment_dtls
5218: (
5219: adjustment_dtl_id,
5220: adjustment_id,
5221: cost_cmpntcls_id,

Line 5245: FROM gmf_lot_cost_adjustment_dtls a,

5241: SYSDATE,
5242: a.last_updated_by,
5243: a.last_update_login,
5244: SYSDATE
5245: FROM gmf_lot_cost_adjustment_dtls a,
5246: gmf_lot_cost_adjustments b
5247: WHERE a.adjustment_id = b.text_code
5248: AND b.text_code IS NOT NULL
5249: AND (

Line 5257: FROM gmf_lot_cost_adjustment_dtls x

5253: OR (b.legal_entity_id IS NOT NULL AND b.co_code IS NULL)
5254: )
5255: AND NOT EXISTS (
5256: SELECT 'RECORD_ALREADY_EXISTS'
5257: FROM gmf_lot_cost_adjustment_dtls x
5258: WHERE b.adjustment_id = x.adjustment_id
5259: )
5260: );
5261: EXCEPTION