APPS.OE_DELAYED_REQUESTS_PVT dependencies on OE_ORDER_LINES_ALL

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;