DBA Data[Home] [Help]

APPS.MSC_ATP_UTILS dependencies on OE_ORDER_LINES_ALL

Line 2783: from oe_order_lines_all o

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

Line 3146: oe_order_lines_all oe

3142: where prha.requisition_header_id = mast.source_doc_id),
3143: INTERNAL_ORG_ID = -- Bug 3449812
3144: (Select po.destination_organization_id
3145: from po_requisition_lines_all po,
3146: oe_order_lines_all oe
3147: where oe.source_document_line_id = po.requisition_line_id
3148: and oe.line_id = mast.order_line_id)
3149: where mast.session_id = p_session_id
3150: --bug 3378648: only update request data