eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POR_RCV_POST_QUERY_PKG dependencies on PO_REQUISITION_LINES_ALL

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