DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on OE_ORDER_LINES_ALL

Line 2094: , oe_order_lines_all oola

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
2098: (SELECT msi.inventory_item_id

Line 2117: , oe_order_lines_all oola

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
2121: AND oha.order_type_id = ttt.transaction_type_id

Line 2132: FROM oe_order_lines_all oola

2128: AND ttt.language = USERENV('LANG');
2129:
2130: CURSOR c_order_line IS
2131: SELECT 1
2132: FROM oe_order_lines_all oola
2133: WHERE oola.header_id = p_sample_rec.order_id
2134: AND NVL( p_sample_rec.ship_to_site_id, oola.ship_to_org_id) = oola.ship_to_org_id
2135: AND oola.inventory_item_id IN
2136: (SELECT msi.inventory_item_id