DBA Data[Home] [Help]

APPS.PO_RCO_VALIDATION_PVT dependencies on PO_SYSTEM_PARAMETERS

Line 4873: po_system_parameters POSP

4869: (SELECT 'so line is not cancelled'
4870: FROM
4871: po_requisition_lines PORL,
4872: po_requisition_headers_all PORH, --
4873: po_system_parameters POSP
4874: WHERE
4875: PORL.requisition_line_id = p_req_line_id AND
4876: PORL.requisition_header_id = PORH.requisition_header_id AND
4877: (OE_ORDER_IMPORT_INTEROP_PUB.Get_Open_Qty(posp.order_source_id, porh.requisition_header_id, porl.requisition_line_id))>0)

Line 4882: po_system_parameters POSP

4878: AND NOT EXISTS
4879: (SELECT 'line in interface table'
4880: FROM
4881: oe_headers_iface_all SOHI,
4882: po_system_parameters POSP
4883: WHERE
4884: SOHI.orig_sys_document_ref = to_char(PRH.requisition_header_id)
4885: AND SOHI.order_source_id = POSP.order_source_id));
4886: