DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on OE_TRANSACTION_TYPES_TL

Line 2095: , oe_transaction_types_tl ttt

2091: /*CURSOR c_order IS
2092: SELECT 1
2093: FROM oe_order_headers_all oha
2094: , oe_order_lines_all oola
2095: , oe_transaction_types_tl ttt
2096: WHERE oola.header_id = oha.header_id
2097: AND oola.inventory_item_id IN
2098: (SELECT msi.inventory_item_id
2099: FROM mtl_system_items msi

Line 2118: , oe_transaction_types_tl ttt

2114: CURSOR c_order IS
2115: SELECT 1
2116: FROM oe_order_headers_all oha
2117: , oe_order_lines_all oola
2118: , oe_transaction_types_tl ttt
2119: WHERE oola.header_id = oha.header_id
2120: AND oola.inventory_item_id = p_sample_rec.inventory_item_id
2121: AND oha.order_type_id = ttt.transaction_type_id
2122: AND (NVL( p_sample_rec.ship_to_site_id, oola.ship_to_org_id) = oola.ship_to_org_id -- 5335008