APPS.GMD_SPEC_VRS_GRP dependencies on OE_ORDER_HEADERS_ALL

Line 2774: FROM oe_order_headers_all oha

2770: AND csua.site_use_id = p_cust_vr.ship_to_site_id;
2771:
2772: CURSOR c_order IS
2773: SELECT 1
2774: FROM oe_order_headers_all oha
2775: , oe_order_lines_all oola
2776: , oe_transaction_types_tl ttt
2777: WHERE oola.header_id = oha.header_id
2778: AND oola.inventory_item_id = p_spec.inventory_item_id