DBA Data[Home] [Help]

APPS.POR_RCV_POST_QUERY_PKG dependencies on PO_REQUISITION_LINES

Line 101: po_requisition_lines b

97: begin
98: select a.segment1, a.requisition_header_id
99: into pReqNum, pReqHeaderId
100: from po_requisition_headers a,
101: po_requisition_lines b
102: where a.requisition_header_id = b.requisition_header_id
103: and b.requisition_line_id = pReqLineId;
104: exception
105: when no_data_found then

Line 123: po_requisition_lines prl,

119: begin
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

Line 178: FROM PO_REQUISITION_LINES_ALL PRL,

174: SELECT ORDER_NUM
175: INTO xOrderNumber
176: FROM (
177: SELECT DISTINCT PH.SEGMENT1 || DECODE(PR.RELEASE_NUM, NULL, '', '-' || PR.RELEASE_NUM) ORDER_NUM
178: FROM PO_REQUISITION_LINES_ALL PRL,
179: PO_LINE_LOCATIONS_ALL PLL,
180: PO_HEADERS_ALL PH,
181: PO_RELEASES_ALL PR
182: WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND

Line 189: PO_REQUISITION_LINES_ALL PORL,

185: PRL.REQUISITION_HEADER_ID = pReqHeaderId
186: UNION ALL
187: SELECT DISTINCT to_char(OSH.ORDER_NUMBER) ORDER_NUM
188: FROM PO_REQUISITION_HEADERS_ALL PORH,
189: PO_REQUISITION_LINES_ALL PORL,
190: OE_ORDER_HEADERS OSH,
191: PO_SYSTEM_PARAMETERS POSP
192: WHERE PORL.SOURCE_TYPE_CODE = 'INVENTORY' AND
193: OSH.ORDER_SOURCE_ID = POSP.ORDER_SOURCE_ID AND

Line 217: FROM PO_REQUISITION_LINES_ALL PRL,

213: SELECT SUPPLIER
214: INTO xSupplier
215: FROM (
216: SELECT DISTINCT PV.VENDOR_NAME SUPPLIER
217: FROM PO_REQUISITION_LINES_ALL PRL,
218: PO_LINE_LOCATIONS_ALL PLL,
219: PO_HEADERS_ALL PH,
220: PO_VENDORS PV
221: WHERE PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID AND

Line 227: FROM PO_REQUISITION_LINES_ALL PRL,

223: PH.VENDOR_ID = PV.VENDOR_ID AND
224: PRL.REQUISITION_HEADER_ID = pReqHeaderId
225: UNION ALL
226: SELECT DISTINCT HAOU.NAME SUPPLIER
227: FROM PO_REQUISITION_LINES_ALL PRL,
228: HR_ALL_ORGANIZATION_UNITS_TL HAOU
229: WHERE PRL.SOURCE_TYPE_CODE = 'INVENTORY' AND
230: HAOU.ORGANIZATION_ID = PRL.SOURCE_ORGANIZATION_ID AND
231: HAOU.LANGUAGE = USERENV('LANG') AND