DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 2093: FROM oe_order_headers_all oha

2089: AND csua.site_use_id = p_sample_rec.ship_to_site_id;
2090:
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

Line 2116: FROM oe_order_headers_all oha

2112: --CURSOR c_order rewritten as part of bug# 4916871
2113: --CURSOR c_order rewritten as part of bug# 5335008
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