APPS.MSC_ATP_PEG dependencies on MRP_ATP_DETAILS_TEMP

Line 6927: FROM mrp_atp_details_temp

6923: DECODE (pegging_type, :l_peg_type18,
6924: identifier3, NULL) end_demand_id,
6925: created_by, creation_date, last_updated_by, last_update_date,
6926: customer_id, customer_site_id
6927: FROM mrp_atp_details_temp
6928: WHERE pegging_id = :p_identifier
6929: AND identifier1 = :p_instance_id
6930: AND record_type = 3
6931: and session_id = :l_session_id

Line 7064: FROM mrp_atp_details_temp peg,

7060: DECODE(:G_ALLOCATION_METHOD, 2, 2,
7061: decode(alloc.inventory_item_id, null, 2 , 1)
7062: )
7063: ) offset_type
7064: FROM mrp_atp_details_temp peg,
7065: msc_item_hierarchy_mv alloc,
7066: msc_system_items lid
7067: WHERE peg.pegging_id = :p_identifier
7068: AND peg.identifier1 = :p_instance_id

Line 7143: FROM mrp_atp_details_temp

7139: identifier3, NULL) end_demand_id
7140: INTO l_reference_item_id, l_plan_id, l_end_demand_id
7141: -- End CTO_PF_PRJ Get End Demand Id
7142: -- Bug 3334643 Track the plan_id
7143: FROM mrp_atp_details_temp
7144: WHERE pegging_id = p_identifier
7145: AND identifier1 = p_instance_id
7146: AND record_type = 3
7147: AND model_sd_flag = 1

Line 7247: FROM mrp_atp_details_temp

7243: NULL daily_relief_qty,
7244: pegging_id, parent_pegging_id, end_pegging_id, :l_end_demand_id,
7245: created_by, creation_date, last_updated_by, last_update_date,
7246: customer_id, customer_site_id
7247: FROM mrp_atp_details_temp
7248: WHERE pegging_id <> :p_identifier
7249: AND record_type in (3, 4)
7250: and session_id = :l_session_id
7251: and model_sd_flag = 1 -- ensure that we only obtain pegging for things in the order.

Line 7391: FROM mrp_atp_details_temp peg,

7387: DECODE(:G_ALLOCATION_METHOD, 2, 2,
7388: decode(alloc.inventory_item_id, null, 2 , 1)
7389: )
7390: ) offset_type
7391: FROM mrp_atp_details_temp peg,
7392: msc_item_hierarchy_mv alloc,
7393: msc_system_items lid
7394: WHERE peg.pegging_id <> :p_identifier
7395: AND peg.record_type in (3, 4)