DBA Data[Home] [Help]

APPS.OE_VALIDATE_HEADER dependencies on OE_BLANKET_HEADERS_EXT

Line 735: FROM OE_BLANKET_HEADERS BH,OE_BLANKET_HEADERS_EXT BHE

731: l_on_hold_flag,
732: l_start_date_active,
733: l_end_date_active,
734: l_flow_status_code
735: FROM OE_BLANKET_HEADERS BH,OE_BLANKET_HEADERS_EXT BHE
736: WHERE BH.ORDER_NUMBER = p_header_rec.blanket_number
737: AND BH.ORDER_NUMBER = BHE.ORDER_NUMBER
738: AND BH.SALES_DOCUMENT_TYPE_CODE = 'B'
739: AND NVL(BH.TRANSACTION_PHASE_CODE,'F')='F'