DBA Data[Home] [Help]

APPS.PORCPTWF dependencies on PO_REQUISITION_LINES

Line 449: from PO_REQUISITION_LINES PORL,

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

Line 812: from PO_REQUISITION_LINES PORL

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

Line 2557: po_requisition_lines prl,po_distributions pod,

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