APPS.MSC_ATP_PEG dependencies on MRP_ATP_DETAILS_TEMP

Line 6848: FROM mrp_atp_details_temp

6844: DECODE (pegging_type, :l_peg_type18,
6845: identifier3, NULL) end_demand_id,
6846: created_by, creation_date, last_updated_by, last_update_date,
6847: customer_id, customer_site_id
6848: FROM mrp_atp_details_temp
6849: WHERE pegging_id = :p_identifier
6850: AND identifier1 = :p_instance_id
6851: AND record_type = 3
6852: and session_id = :l_session_id

Line 6905: FROM mrp_atp_details_temp

6901: identifier3, NULL) end_demand_id
6902: INTO l_reference_item_id, l_plan_id, l_end_demand_id
6903: -- End CTO_PF_PRJ Get End Demand Id
6904: -- Bug 3334643 Track the plan_id
6905: FROM mrp_atp_details_temp
6906: WHERE pegging_id = p_identifier
6907: AND identifier1 = p_instance_id
6908: AND record_type = 3
6909: AND model_sd_flag = 1

Line 7006: FROM mrp_atp_details_temp

7002: NULL daily_relief_qty,
7003: pegging_id, parent_pegging_id, end_pegging_id, :l_end_demand_id,
7004: created_by, creation_date, last_updated_by, last_update_date,
7005: customer_id, customer_site_id
7006: FROM mrp_atp_details_temp
7007: WHERE pegging_id <> :p_identifier
7008: AND record_type in (3, 4)
7009: and session_id = :l_session_id
7010: and model_sd_flag = 1 -- ensure that we only obtain pegging for things in the order.