DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on OE_ORDER_LINES_ALL

Line 2775: , oe_order_lines_all oola

2771:
2772: CURSOR c_order IS
2773: SELECT 1
2774: FROM oe_order_headers_all oha
2775: , oe_order_lines_all oola
2776: , oe_transaction_types_tl ttt
2777: WHERE oola.header_id = oha.header_id
2778: AND oola.inventory_item_id = p_spec.inventory_item_id
2779: AND oha.order_type_id = ttt.transaction_type_id

Line 2790: FROM oe_order_lines_all oola

2786:
2787:
2788: CURSOR c_order_line IS
2789: SELECT 1
2790: FROM oe_order_lines_all oola
2791: WHERE oola.header_id = p_cust_vr.order_id
2792: AND NVL( p_cust_vr.ship_to_site_id, oola.ship_to_org_id) = oola.ship_to_org_id
2793: AND oola.inventory_item_id = p_spec.inventory_item_id
2794: AND oola.header_id = p_cust_vr.order_id