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_VIEW_REQS_PKG dependencies on PO_SYSTEM_PARAMETERS

Line 412: PO_SYSTEM_PARAMETERS PSP

408: from PO_REQUISITION_LINES PRL,
409: PO_REQUISITION_HEADERS PRH,
410: OE_ORDER_HEADERS_ALL OOH,
411: OE_ORDER_LINES_ALL OOL,
412: PO_SYSTEM_PARAMETERS PSP
413: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
414: AND PRL.REQUISITION_LINE_ID = req_line_id
415: AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF
416: AND OOL.HEADER_ID = OOH.HEADER_ID

Line 446: PO_SYSTEM_PARAMETERS PSP

442: from PO_REQUISITION_LINES PRL,
443: PO_REQUISITION_HEADERS PRH,
444: OE_ORDER_HEADERS_ALL OOH,
445: OE_ORDER_LINES_ALL OOL,
446: PO_SYSTEM_PARAMETERS PSP
447: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
448: AND PRL.REQUISITION_LINE_ID = req_line_id
449: AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF
450: AND OOL.HEADER_ID = OOH.HEADER_ID

Line 467: PO_SYSTEM_PARAMETERS PSP

463: from PO_REQUISITION_LINES PRL,
464: PO_REQUISITION_HEADERS PRH,
465: OE_ORDER_HEADERS_ALL OOH,
466: OE_ORDER_LINES_ALL OOL,
467: PO_SYSTEM_PARAMETERS PSP
468: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
469: AND PRL.REQUISITION_LINE_ID = req_line_id
470: AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF
471: AND OOL.HEADER_ID = OOH.HEADER_ID

Line 496: PO_SYSTEM_PARAMETERS PSP

492: from PO_REQUISITION_LINES PRL,
493: PO_REQUISITION_HEADERS PRH,
494: OE_ORDER_HEADERS_ALL OOH,
495: OE_ORDER_LINES_ALL OOL,
496: PO_SYSTEM_PARAMETERS PSP
497: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
498: AND PRL.REQUISITION_LINE_ID = req_line_id
499: AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF
500: AND OOL.HEADER_ID = OOH.HEADER_ID

Line 616: PO_SYSTEM_PARAMETERS_ALL PSP

612: from PO_REQUISITION_LINES_ALL PRL,
613: PO_REQUISITION_HEADERS_ALL PRH,
614: OE_ORDER_HEADERS_ALL OOH,
615: OE_ORDER_LINES_ALL OOL,
616: PO_SYSTEM_PARAMETERS_ALL PSP
617: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
618: AND PRL.REQUISITION_LINE_ID = req_line_id
619: AND NVL(OOH.ORG_ID, -99) = NVL(PSP.ORG_ID, -99)
620: AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF

Line 1356: PO_SYSTEM_PARAMETERS PSP

1352: PO_REQUISITION_HEADERS PRH,
1353: PO_REQUISITION_LINES_ALL PRL,
1354: OE_ORDER_HEADERS_ALL OOH,
1355: OE_ORDER_LINES_ALL OOL,
1356: PO_SYSTEM_PARAMETERS PSP
1357: WHERE
1358: OOH.ORDER_SOURCE_ID = PSP.ORDER_SOURCE_ID AND
1359: OOH.ORIG_SYS_DOCUMENT_REF = PRH.SEGMENT1 AND
1360: OOH.SOURCE_DOCUMENT_ID = PRH.REQUISITION_HEADER_ID AND

Line 1447: PO_SYSTEM_PARAMETERS PSP

1443: PO_REQUISITION_HEADERS PRH,
1444: PO_REQUISITION_LINES_ALL PRL,
1445: OE_ORDER_HEADERS_ALL OOH,
1446: OE_ORDER_LINES_ALL OOL,
1447: PO_SYSTEM_PARAMETERS PSP
1448: WHERE
1449: OOH.ORDER_SOURCE_ID = PSP.ORDER_SOURCE_ID AND
1450: OOH.ORIG_SYS_DOCUMENT_REF = PRH.SEGMENT1 AND
1451: OOH.HEADER_ID = OOL.HEADER_ID AND