DBA Data[Home] [Help]

APPS.MSC_ATP_UTILS dependencies on OE_ORDER_LINES_ALL

Line 2785: from oe_order_lines_all o

2781: update mrp_atp_schedule_temp mast
2782: set (mast.old_source_organization_id, mast.Old_Demand_Class )=
2783: (SELECT mast.Source_Organization_Id,
2784: NVL(mast.Old_Demand_Class, mast.demand_class)
2785: from oe_order_lines_all o
2786: where o.line_id = mast.order_line_id and
2787: o.schedule_ship_date is not NULL
2788: )
2789: where mast.Old_Source_Organization_Id is NULL and

Line 3200: oe_order_lines_all oe

3196: where prha.requisition_header_id = mast.source_doc_id),
3197: INTERNAL_ORG_ID = -- Bug 3449812
3198: (Select po.destination_organization_id
3199: from po_requisition_lines_all po,
3200: oe_order_lines_all oe
3201: where oe.source_document_line_id = po.requisition_line_id
3202: and oe.line_id = mast.order_line_id)
3203: where mast.session_id = p_session_id
3204: --bug 3378648: only update request data