APPS.OE_DELAYED_REQUESTS_PVT dependencies on OE_ORDER_LINES

Line 167: from oe_order_lines_all

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

Line 3695: FROM OE_ORDER_LINES_ALL

3691: source_document_line_id, orig_sys_shipment_ref, header_id
3692: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
3693: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
3694: l_source_document_line_id, l_orig_sys_shipment_ref, l_header_id
3695: FROM OE_ORDER_LINES_ALL
3696: WHERE line_id = l_request_rec.entity_id;
3697: EXCEPTION
3698: WHEN NO_DATA_FOUND THEN
3699: l_header_id := null;

Line 3791: FROM OE_ORDER_LINES_ALL

3787: source_document_line_id, orig_sys_shipment_ref, header_id
3788: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
3789: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
3790: l_source_document_line_id, l_orig_sys_shipment_ref, l_header_id
3791: FROM OE_ORDER_LINES_ALL
3792: WHERE line_id = l_line_id;
3793: EXCEPTION
3794: WHEN NO_DATA_FOUND THEN
3795: l_header_id := null;

Line 3887: FROM OE_ORDER_LINES_ALL

3883: source_document_line_id, orig_sys_shipment_ref, header_id
3884: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
3885: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
3886: l_source_document_line_id, l_orig_sys_shipment_ref, l_header_id
3887: FROM OE_ORDER_LINES_ALL
3888: WHERE line_id = l_line_id;
3889: EXCEPTION
3890: WHEN NO_DATA_FOUND THEN
3891: l_header_id := null;

Line 4548: FROM oe_order_lines

4544: oe_debug_pub.add('another req for same top model', 2);
4545: END IF;
4546: SELECT ato_line_id
4547: INTO l_ato_line_id
4548: FROM oe_order_lines
4549: WHERE line_id = G_Delayed_Requests(K).entity_id;
4550:
4551: IF nvl(l_ato_line_id, -1) <> G_Delayed_Requests(K).entity_id THEN
4552: IF l_debug_level > 0 THEN

Line 4595: FROM oe_order_lines

4591:
4592: IF G_Delayed_Requests(K).param9 = 'Y' THEN
4593: SELECT ato_line_id
4594: INTO l_ato_line_id
4595: FROM oe_order_lines
4596: WHERE line_id = G_Delayed_Requests(K).entity_id;
4597: END IF;
4598:
4599: IF l_ato_line_id is NULL THEN