DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on OE_ORDER_LINES_ALL

Line 1964: , oe_order_lines_all oola

1960:
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

Line 1987: , oe_order_lines_all oola

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

Line 2002: FROM oe_order_lines_all oola

1998: AND ttt.language = USERENV('LANG');
1999:
2000: CURSOR c_order_line IS
2001: SELECT 1
2002: FROM oe_order_lines_all oola
2003: WHERE oola.header_id = p_sample_rec.order_id
2004: AND NVL( p_sample_rec.ship_to_site_id, oola.ship_to_org_id) = oola.ship_to_org_id
2005: AND oola.inventory_item_id IN
2006: (SELECT msi.inventory_item_id