DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on OE_ORDER_LINES_ALL

Line 2924: , oe_order_lines_all oola

2920:
2921: CURSOR c_order IS
2922: SELECT 1
2923: FROM oe_order_headers_all oha
2924: , oe_order_lines_all oola
2925: , oe_transaction_types_tl ttt
2926: WHERE oola.header_id = oha.header_id
2927: AND oola.inventory_item_id = p_spec.inventory_item_id
2928: AND oha.order_type_id = ttt.transaction_type_id

Line 2939: FROM oe_order_lines_all oola

2935:
2936:
2937: CURSOR c_order_line IS
2938: SELECT 1
2939: FROM oe_order_lines_all oola
2940: WHERE oola.header_id = p_cust_vr.order_id
2941: AND NVL( p_cust_vr.ship_to_site_id, oola.ship_to_org_id) = oola.ship_to_org_id
2942: AND oola.inventory_item_id = p_spec.inventory_item_id
2943: AND oola.header_id = p_cust_vr.order_id