DBA Data[Home] [Help]

APPS.OE_VALIDATE_HEADER dependencies on OE_BLANKET_HEADERS_EXT

Line 766: FROM OE_BLANKET_HEADERS BH,OE_BLANKET_HEADERS_EXT BHE

762: l_on_hold_flag,
763: l_start_date_active,
764: l_end_date_active,
765: l_flow_status_code
766: FROM OE_BLANKET_HEADERS BH,OE_BLANKET_HEADERS_EXT BHE
767: WHERE BH.ORDER_NUMBER = p_header_rec.blanket_number
768: AND BH.ORDER_NUMBER = BHE.ORDER_NUMBER
769: AND BH.SALES_DOCUMENT_TYPE_CODE = 'B'
770: AND NVL(BH.TRANSACTION_PHASE_CODE,'F')='F'