APPS.GMF_MIGRATION dependencies on GMF_LOT_COST_DETAILS

Line 4435: INSERT INTO gmf_lot_cost_details

4431: BEGIN
4432: /****************************************************************************
4433: * Insert rows for Additional Lots Created as part of Lot Balances Migration *
4434: ****************************************************************************/
4435: INSERT INTO gmf_lot_cost_details
4436: (
4437: header_id,
4438: detail_id,
4439: cost_cmpntcls_id,

Line 4535: FROM gmf_lot_cost_details a,

4531: a.last_update_login,
4532: a.detail_id,
4533: a.delete_mark,
4534: a.final_cost_flag
4535: FROM gmf_lot_cost_details a,
4536: gmf_lot_costs b
4537: WHERE a.header_id = b.text_code
4538: AND b.text_code IS NOT NULL
4539: AND (

Line 4547: FROM gmf_lot_cost_details x

4543: OR (b.lot_number IS NOT NULL AND b.lot_id IS NULL)
4544: )
4545: AND NOT EXISTS (
4546: SELECT 'RECORD_ALREADY_EXISTS'
4547: FROM gmf_lot_cost_details x
4548: WHERE b.header_id = x.header_id
4549: )
4550: );
4551: EXCEPTION