DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on OE_TRANSACTION_TYPES_TL

Line 1965: , oe_transaction_types_tl ttt

1961: /*CURSOR c_order IS
1962: SELECT 1
1963: FROM oe_order_headers_all oha
1964: , oe_order_lines_all oola
1965: , oe_transaction_types_tl ttt
1966: WHERE oola.header_id = oha.header_id
1967: AND oola.inventory_item_id IN
1968: (SELECT msi.inventory_item_id
1969: FROM mtl_system_items msi

Line 1988: , oe_transaction_types_tl ttt

1984: CURSOR c_order IS
1985: SELECT 1
1986: FROM oe_order_headers_all oha
1987: , oe_order_lines_all oola
1988: , oe_transaction_types_tl ttt
1989: WHERE oola.header_id = oha.header_id
1990: AND oola.inventory_item_id = p_sample_rec.inventory_item_id
1991: AND oha.order_type_id = ttt.transaction_type_id
1992: AND (NVL( p_sample_rec.ship_to_site_id, oola.ship_to_org_id) = oola.ship_to_org_id -- 5335008