DBA Data[Home] [Help]

APPS.MSC_ATP_PUB dependencies on OE_ORDER_LINES_ALL

Line 236: oe_order_lines_all oe

232:
233: select min(wf.name)
234: into l_sales_rep
235: from wf_roles wf,
236: oe_order_lines_all oe
237: where oe.line_id = p_atp_rec.identifier(i)
238: and wf.orig_system= 'PER'
239: and wf.orig_system_id= oe.salesrep_id
240: and wf.status='ACTIVE';

Line 603: oe_order_lines_all oe

599: where prha.requisition_header_id = l_atp_rec.attribute_01(i))), --5008194/FP 5054154
600:
601: decode(l_atp_rec.oe_flag(i),'Y', (Select po.destination_organization_id
602: from po_requisition_lines_all po,
603: oe_order_lines_all oe
604: where oe.source_document_line_id = po.requisition_line_id
605: and oe.line_id = l_atp_rec.identifier(i)),NULL), --5008194/FP 5054154
606: p_session_id
607: );