APPS.OE_VALIDATE_HEADER dependencies on OE_ORDER_HEADERS

Line 664: FROM OE_ORDER_HEADERS

660: -- SELECT /* MOAC_SQL_NO_CHANGE */ 'Y'
661: /* INTO l_duplicate_exists
662: FROM DUAL
663: WHERE EXISTS (SELECT 'Y'
664: FROM OE_ORDER_HEADERS
665: WHERE HEADER_ID <> p_header_id
666: AND SOLD_TO_ORG_ID = p_sold_to_org_id
667: AND CUST_PO_NUMBER = p_cust_po_number )
668: OR EXISTS (SELECT 'Y'

Line 682: FROM OE_ORDER_HEADERS

678: SELECT 'Y'
679: INTO l_duplicate_exists
680: FROM DUAL
681: WHERE EXISTS (SELECT 'Y'
682: FROM OE_ORDER_HEADERS
683: WHERE HEADER_ID <> p_header_id
684: AND SOLD_TO_ORG_ID = p_sold_to_org_id
685: AND CUST_PO_NUMBER = p_cust_po_number );
686: EXCEPTION