DBA Data[Home] [Help]

APPS.AHL_OSP_ORDERS_PVT dependencies on OE_ORDER_LINES_ALL

Line 3136: SELECT 'x' from oe_order_lines_all

3132: WHERE osp_order_id = p_osp_order_id
3133: AND oe_return_line_id = p_oe_return_line_id
3134: AND status_code IS NULL;
3135: CURSOR line_already_shipped_csr(p_oe_line_id IN NUMBER) IS
3136: SELECT 'x' from oe_order_lines_all
3137: where line_id = p_oe_line_id AND
3138: shipped_quantity > 0;
3139: l_exist VARCHAR2(1);
3140: l_index NUMBER := 1;

Line 3279: SELECT 'x' FROM ahl_osp_order_lines ol --, oe_order_lines_all oel

3275: --p_new_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type,
3276: --p_old_order_rec IN AHL_OSP_ORDERS_PVT.osp_order_rec_type
3277: ) RETURN BOOLEAN IS
3278: CURSOR order_has_ship_return_csr(p_osp_order_id IN NUMBER) IS
3279: SELECT 'x' FROM ahl_osp_order_lines ol --, oe_order_lines_all oel
3280: WHERE ol.osp_order_id = p_osp_order_id
3281: AND ol.oe_return_line_id IS NOT NULL; --= oel.line_id;
3282: CURSOR order_header_status_csr(p_osp_order_id IN NUMBER) IS
3283: SELECT status_code FROM ahl_osp_orders_b

Line 5058: FROM ahl_osp_order_lines ospl, ahl_osp_orders_b osp, oe_order_lines_all oelship

5054: -- Added by jaramana on January 10, 2008 for the Bug 5547870/5673279
5055: CURSOR check_osp_order_unique(c_osp_order_id NUMBER, c_inventory_item_id NUMBER,
5056: c_inventory_org_id NUMBER, c_serial_number VARCHAR2) IS
5057: SELECT 'X'
5058: FROM ahl_osp_order_lines ospl, ahl_osp_orders_b osp, oe_order_lines_all oelship
5059: WHERE ospl.osp_order_id = osp.osp_order_id
5060: AND osp.status_code <> 'CLOSED'
5061: AND oelship.LINE_ID = ospl.OE_SHIP_LINE_ID
5062: --The order line should not be closed and should not be cancelled to be considered in the uniqueness check