DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on OE_ORDER_HEADERS_ALL

Line 2923: FROM oe_order_headers_all oha

2919: AND csua.site_use_id = p_cust_vr.ship_to_site_id;
2920:
2921: CURSOR c_order IS
2922: SELECT 1
2923: FROM oe_order_headers_all oha
2924: , oe_order_lines_all oola
2925: , oe_transaction_types_tl ttt
2926: WHERE oola.header_id = oha.header_id
2927: AND oola.inventory_item_id = p_spec.inventory_item_id