APPS.OE_DELAYED_REQUESTS_PVT dependencies on OE_ORDER_LINES_ALL

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;