DBA Data[Home] [Help]

APPS.PORCPTWF dependencies on PO_REQ_DISTRIBUTIONS

Line 452: PO_REQ_DISTRIBUTIONS PORD,

448: BEGIN
449: select PORL.auto_receive_flag
450: into x_auto_receive_flag
451: from PO_REQUISITION_LINES PORL,
452: PO_REQ_DISTRIBUTIONS PORD,
453: PO_DISTRIBUTIONS pod
454: where PORD.DISTRIBUTION_ID = POD.REQ_DISTRIBUTION_ID AND
455: PORD.REQUISITION_LINE_ID = PORL.requisition_line_id AND
456: POD.PO_DISTRIBUTION_ID = x_po_distribution_id;

Line 2603: po_req_distributions pord

2599: select prh.segment1
2600: INTO x_req_number
2601: from po_requisition_headers prh,
2602: po_requisition_lines prl,po_distributions pod,
2603: po_req_distributions pord
2604: where pod.po_distribution_id = x_po_distribution_id and
2605: pord.distribution_id = pod.req_distribution_id and
2606: pord.requisition_line_id = prl.requisition_line_id and
2607: prl.requisition_header_id = prh.requisition_header_id;