DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on OE_TRANSACTION_TYPES_TL

Line 2925: , oe_transaction_types_tl ttt

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