DBA Data[Home] [Help]

APPS.PORCPTWF dependencies on PO_REQUISITION_LINES

Line 451: from PO_REQUISITION_LINES PORL,

447:
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

Line 814: from PO_REQUISITION_LINES PORL

810:
811: BEGIN
812: select PORL.auto_receive_flag
813: into x_auto_receive_flag
814: from PO_REQUISITION_LINES PORL
815: where PORL.requisition_line_id = x_requisition_line_ID;
816:
817:
818: EXCEPTION

Line 2602: po_requisition_lines prl,po_distributions pod,

2598:
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