DBA Data[Home] [Help]

APPS.POR_VIEW_REQS_PKG dependencies on PO_SYSTEM_PARAMETERS_ALL

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