DBA Data[Home] [Help]

APPS.OE_CNCL_VALIDATE_HEADER dependencies on OE_ORDER_HEADERS

Line 253: FROM OE_ORDER_HEADERS

249: SELECT /* MOAC_SQL_NO_CHANGE */ 'Y'
250: INTO l_duplicate_exists
251: FROM DUAL
252: WHERE EXISTS (SELECT 'Y'
253: FROM OE_ORDER_HEADERS
254: WHERE HEADER_ID <> p_header_id
255: AND SOLD_TO_ORG_ID = p_sold_to_org_id
256: AND CUST_PO_NUMBER = p_cust_po_number )
257: OR EXISTS (SELECT 'Y'