APPS.OE_DEFAULT_HEADER dependencies on OE_BLANKET_HEADERS_EXT

Line 672: FROM OE_BLANKET_HEADERS BH,OE_BLANKET_HEADERS_EXT BHE

668: end if;
669:
670: SELECT BH.ORDER_NUMBER
671: INTO l_blanket_number
672: FROM OE_BLANKET_HEADERS BH,OE_BLANKET_HEADERS_EXT BHE
673: WHERE BH.CUST_PO_NUMBER = p_cust_po_number
674: AND BH.SOLD_TO_ORG_ID = p_sold_to_org_id
675: AND BHE.ON_HOLD_FLAG = 'N'
676: AND trunc(nvl(l_request_date,sysdate))