[Home] [Help]
1910: mapt.relief_quantity ,
1911: mapt.pegging_id, mapt.prev_pegging_id, mapt.end_pegging_id,
1912: :p_user_id, :p_sysdate, :p_user_id, :p_sysdate,
1913: mv.partner_id, mv.partner_site_id customer_site_id,1
1914: FROM msc_atp_peg_temp mapt, msc_item_hierarchy_mv mv
1915: WHERE mapt.plan_id = :p_plan_id
1916: AND mapt.relief_type = 3
1917: AND mapt.inventory_item_id = mv.inventory_item_id(+)
1918: AND mapt.organization_id = mv.organization_id (+)
1964: mapt.relief_quantity ,
1965: mapt.pegging_id, mapt.prev_pegging_id, mapt.end_pegging_id,
1966: :p_user_id, :p_sysdate, :p_user_id, :p_sysdate,
1967: mv.partner_id, mv.partner_site_id customer_site_id,1
1968: FROM msc_atp_peg_temp mapt, msc_item_hierarchy_mv mv
1969: WHERE mapt.plan_id = :p_plan_id
1970: AND mapt.relief_type = 2
1971: AND mapt.inventory_item_id = mv.inventory_item_id(+)
1972: AND mapt.organization_id = mv.organization_id (+)
6615: decode(alloc.inventory_item_id, null, 2 , 1)
6616: )
6617: ) offset_type
6618: FROM msc_atp_peg_temp mapt, msc_alloc_demands alocd,
6619: msc_system_items msi, msc_item_hierarchy_mv alloc
6620: WHERE mapt.reference_item_id = p_reference_item_id
6621: AND mapt.plan_id = p_plan_id
6622: AND mapt.sales_order_line_id = NVL(p_config_order_line_id, p_model_order_line_id)
6623: --AND mapt.demand_source_type = p_demand_source_type
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
7069: and peg.session_id = :l_session_id
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)
7396: and peg.session_id = :l_session_id