DBA Data[Home] [Help]

APPS.GMF_MIGRATION dependencies on GMF_LOT_COST_DETAILS

Line 4458: INSERT INTO gmf_lot_cost_details

4454: BEGIN
4455: /****************************************************************************
4456: * Insert rows for Additional Lots Created as part of Lot Balances Migration *
4457: ****************************************************************************/
4458: INSERT INTO gmf_lot_cost_details
4459: (
4460: header_id,
4461: detail_id,
4462: cost_cmpntcls_id,

Line 4558: FROM gmf_lot_cost_details a,

4554: a.last_update_login,
4555: a.detail_id,
4556: a.delete_mark,
4557: a.final_cost_flag
4558: FROM gmf_lot_cost_details a,
4559: gmf_lot_costs b
4560: WHERE a.header_id = b.text_code
4561: AND b.text_code IS NOT NULL
4562: AND (

Line 4570: FROM gmf_lot_cost_details x

4566: OR (b.lot_number IS NOT NULL AND b.lot_id IS NULL)
4567: )
4568: AND NOT EXISTS (
4569: SELECT 'RECORD_ALREADY_EXISTS'
4570: FROM gmf_lot_cost_details x
4571: WHERE b.header_id = x.header_id
4572: )
4573: );
4574: EXCEPTION