DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on OE_TRANSACTION_TYPES_TL

Line 2776: , oe_transaction_types_tl ttt

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
2779: AND oha.order_type_id = ttt.transaction_type_id
2780: AND NVL( p_cust_vr.ship_to_site_id, oola.ship_to_org_id) = oola.ship_to_org_id