DBA Data[Home] [Help]

APPS.PO_RCO_VALIDATION_PVT dependencies on PO_SYSTEM_PARAMETERS

Line 5009: po_system_parameters POSP

5005: (SELECT 'so line is not cancelled'
5006: FROM
5007: po_requisition_lines PORL,
5008: po_requisition_headers_all PORH, --
5009: po_system_parameters POSP
5010: WHERE
5011: PORL.requisition_line_id = p_req_line_id AND
5012: PORL.requisition_header_id = PORH.requisition_header_id AND
5013: (OE_ORDER_IMPORT_INTEROP_PUB.Get_Open_Qty(posp.order_source_id, porh.requisition_header_id, porl.requisition_line_id))>0)

Line 5018: po_system_parameters POSP

5014: AND NOT EXISTS
5015: (SELECT 'line in interface table'
5016: FROM
5017: oe_headers_iface_all SOHI,
5018: po_system_parameters POSP
5019: WHERE
5020: SOHI.orig_sys_document_ref = to_char(PRH.requisition_header_id)
5021: AND SOHI.order_source_id = POSP.order_source_id));
5022: