DBA Data[Home] [Help]

APPS.PORCPTWF dependencies on PO_REQ_DISTRIBUTIONS

Line 450: PO_REQ_DISTRIBUTIONS PORD,

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

Line 2558: po_req_distributions pord

2554: select prh.segment1
2555: INTO x_req_number
2556: from po_requisition_headers prh,
2557: po_requisition_lines prl,po_distributions pod,
2558: po_req_distributions pord
2559: where pod.po_distribution_id = x_po_distribution_id and
2560: pord.distribution_id = pod.req_distribution_id and
2561: pord.requisition_line_id = prl.requisition_line_id and
2562: prl.requisition_header_id = prh.requisition_header_id;