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.

[Home] [Help]

APPS.POR_VIEW_REQS_PKG dependencies on PO_SYSTEM_PARAMETERS

Line 336: PO_SYSTEM_PARAMETERS PSP

332: from PO_REQUISITION_LINES PRL,
333: PO_REQUISITION_HEADERS PRH,
334: OE_ORDER_HEADERS_ALL OOH,
335: OE_ORDER_LINES_ALL OOL,
336: PO_SYSTEM_PARAMETERS PSP
337: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
338: AND PRL.REQUISITION_LINE_ID = req_line_id
339: AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF
340: AND OOL.HEADER_ID = OOH.HEADER_ID

Line 369: PO_SYSTEM_PARAMETERS PSP

365: from PO_REQUISITION_LINES PRL,
366: PO_REQUISITION_HEADERS PRH,
367: OE_ORDER_HEADERS_ALL OOH,
368: OE_ORDER_LINES_ALL OOL,
369: PO_SYSTEM_PARAMETERS PSP
370: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
371: AND PRL.REQUISITION_LINE_ID = req_line_id
372: AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF
373: AND OOL.HEADER_ID = OOH.HEADER_ID

Line 390: PO_SYSTEM_PARAMETERS PSP

386: from PO_REQUISITION_LINES PRL,
387: PO_REQUISITION_HEADERS PRH,
388: OE_ORDER_HEADERS_ALL OOH,
389: OE_ORDER_LINES_ALL OOL,
390: PO_SYSTEM_PARAMETERS PSP
391: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
392: AND PRL.REQUISITION_LINE_ID = req_line_id
393: AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF
394: AND OOL.HEADER_ID = OOH.HEADER_ID

Line 419: PO_SYSTEM_PARAMETERS PSP

415: from PO_REQUISITION_LINES PRL,
416: PO_REQUISITION_HEADERS PRH,
417: OE_ORDER_HEADERS_ALL OOH,
418: OE_ORDER_LINES_ALL OOL,
419: PO_SYSTEM_PARAMETERS PSP
420: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
421: AND PRL.REQUISITION_LINE_ID = req_line_id
422: AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF
423: AND OOL.HEADER_ID = OOH.HEADER_ID

Line 539: PO_SYSTEM_PARAMETERS_ALL PSP

535: from PO_REQUISITION_LINES_ALL PRL,
536: PO_REQUISITION_HEADERS_ALL PRH,
537: OE_ORDER_HEADERS_ALL OOH,
538: OE_ORDER_LINES_ALL OOL,
539: PO_SYSTEM_PARAMETERS_ALL PSP
540: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
541: AND PRL.REQUISITION_LINE_ID = req_line_id
542: AND NVL(OOH.ORG_ID, -99) = NVL(PSP.ORG_ID, -99)
543: AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF

Line 1233: PO_SYSTEM_PARAMETERS PSP

1229: PO_REQUISITION_HEADERS PRH,
1230: PO_REQUISITION_LINES_ALL PRL,
1231: OE_ORDER_HEADERS_ALL OOH,
1232: OE_ORDER_LINES_ALL OOL,
1233: PO_SYSTEM_PARAMETERS PSP
1234: WHERE
1235: OOH.ORDER_SOURCE_ID = PSP.ORDER_SOURCE_ID AND
1236: OOH.ORIG_SYS_DOCUMENT_REF = PRH.SEGMENT1 AND
1237: OOH.SOURCE_DOCUMENT_ID = PRH.REQUISITION_HEADER_ID AND

Line 1324: PO_SYSTEM_PARAMETERS PSP

1320: PO_REQUISITION_HEADERS PRH,
1321: PO_REQUISITION_LINES_ALL PRL,
1322: OE_ORDER_HEADERS_ALL OOH,
1323: OE_ORDER_LINES_ALL OOL,
1324: PO_SYSTEM_PARAMETERS PSP
1325: WHERE
1326: OOH.ORDER_SOURCE_ID = PSP.ORDER_SOURCE_ID AND
1327: OOH.ORIG_SYS_DOCUMENT_REF = PRH.SEGMENT1 AND
1328: OOH.HEADER_ID = OOL.HEADER_ID AND