DBA Data[Home] [Help]

APPS.POR_VIEW_REQS_PKG dependencies on PO_SYSTEM_PARAMETERS_ALL

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