APPS.OE_DELAYED_REQUESTS_PVT dependencies on OE_ORDER_LINES

Line 168: from oe_order_lines_all

164:
165: IS
166: cursor included_lines_cur(p_header_id in number) is
167: select line_id
168: from oe_order_lines_all
169: where header_id = p_header_id
170: and item_type_code = 'INCLUDED';
171:
172: l_request_rec OE_Order_PUB.request_rec_type;

Line 4133: FROM OE_ORDER_LINES_ALL

4129: source_document_line_id, orig_sys_shipment_ref, header_id
4130: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
4131: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
4132: l_source_document_line_id, l_orig_sys_shipment_ref, l_header_id
4133: FROM OE_ORDER_LINES_ALL
4134: WHERE line_id = l_request_rec.entity_id;
4135: EXCEPTION
4136: WHEN NO_DATA_FOUND THEN
4137: l_header_id := null;

Line 4229: FROM OE_ORDER_LINES_ALL

4225: source_document_line_id, orig_sys_shipment_ref, header_id
4226: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
4227: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
4228: l_source_document_line_id, l_orig_sys_shipment_ref, l_header_id
4229: FROM OE_ORDER_LINES_ALL
4230: WHERE line_id = l_line_id;
4231: EXCEPTION
4232: WHEN NO_DATA_FOUND THEN
4233: l_header_id := null;

Line 4325: FROM OE_ORDER_LINES_ALL

4321: source_document_line_id, orig_sys_shipment_ref, header_id
4322: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
4323: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
4324: l_source_document_line_id, l_orig_sys_shipment_ref, l_header_id
4325: FROM OE_ORDER_LINES_ALL
4326: WHERE line_id = l_line_id;
4327: EXCEPTION
4328: WHEN NO_DATA_FOUND THEN
4329: l_header_id := null;

Line 5000: FROM oe_order_lines

4996: oe_debug_pub.add('another req for same top model', 2);
4997: END IF;
4998: SELECT ato_line_id
4999: INTO l_ato_line_id
5000: FROM oe_order_lines
5001: WHERE line_id = G_Delayed_Requests(K).entity_id;
5002:
5003: IF nvl(l_ato_line_id, -1) <> G_Delayed_Requests(K).entity_id THEN
5004: IF l_debug_level > 0 THEN

Line 5047: FROM oe_order_lines

5043:
5044: IF G_Delayed_Requests(K).param9 = 'Y' OR OE_Config_Util.G_Config_UI_Used ='N' THEN --13007721
5045: SELECT ato_line_id
5046: INTO l_ato_line_id
5047: FROM oe_order_lines
5048: WHERE line_id = G_Delayed_Requests(K).entity_id;
5049: END IF;
5050:
5051: IF l_ato_line_id is NULL THEN