DBA Data[Home] [Help]

APPS.POR_RCV_POST_QUERY_PKG dependencies on PO_DISTRIBUTIONS

Line 124: po_distributions pod,

120: select prh.segment1,prl.requisition_line_id,prh.requisition_header_id
121: into pReqNum, pReqLineId, pReqHeaderId
122: from po_requisition_headers prh,
123: po_requisition_lines prl,
124: po_distributions pod,
125: po_req_distributions pord
126: where pod.po_distribution_id= pDistributionId
127: and pord.distribution_id = pod.req_distribution_id
128: and pord.requisition_line_id = prl.requisition_line_id

Line 146: po_distributions pod

142: begin
143: select pol.vendor_product_num, pod.distribution_num
144: into pSPN, pDistributionNum
145: from po_lines pol,
146: po_distributions pod
147: where pod.po_line_id = pol.po_line_id
148: and pod.po_distribution_id = pDistributionId;
149: exception
150: when no_data_found then