APPS.OE_ORDER_PVT dependencies on OE_ORDER_LINES_ALL

Line 3808: FROM OE_ORDER_LINES_ALL

3804: source_document_line_id, orig_sys_shipment_ref
3805: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
3806: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
3807: l_source_document_line_id, l_orig_sys_shipment_ref
3808: FROM OE_ORDER_LINES_ALL
3809: WHERE line_id = l_line_Scredit_rec.line_id;
3810: EXCEPTION
3811: WHEN NO_DATA_FOUND THEN
3812: l_order_source_id := null;

Line 3859: FROM OE_ORDER_LINES_ALL

3855: source_document_line_id, orig_sys_shipment_ref
3856: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
3857: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
3858: l_source_document_line_id, l_orig_sys_shipment_ref
3859: FROM OE_ORDER_LINES_ALL
3860: WHERE line_id = l_old_line_Scredit_rec.line_id;
3861: EXCEPTION
3862: WHEN NO_DATA_FOUND THEN
3863: l_order_source_id := null;

Line 4390: FROM OE_ORDER_LINES_ALL

4386: source_document_line_id, orig_sys_shipment_ref
4387: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
4388: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
4389: l_source_document_line_id, l_orig_sys_shipment_ref
4390: FROM OE_ORDER_LINES_ALL
4391: WHERE line_id = l_line_Payment_rec.line_id;
4392: EXCEPTION
4393: WHEN NO_DATA_FOUND THEN
4394: l_order_source_id := null;

Line 4441: FROM OE_ORDER_LINES_ALL

4437: source_document_line_id, orig_sys_shipment_ref
4438: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
4439: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
4440: l_source_document_line_id, l_orig_sys_shipment_ref
4441: FROM OE_ORDER_LINES_ALL
4442: WHERE line_id = l_old_line_Payment_rec.line_id;
4443: EXCEPTION
4444: WHEN NO_DATA_FOUND THEN
4445: l_order_source_id := null;

Line 5803: FROM OE_ORDER_LINES_ALL

5799:
5800: BEGIN
5801: SELECT header_id
5802: INTO l_header_id
5803: FROM OE_ORDER_LINES_ALL
5804: WHERE line_id = l_line_id;
5805: EXCEPTION
5806: WHEN NO_DATA_FOUND THEN
5807: null;

Line 6795: FROM oe_order_lines_all

6791: -- Negotiation check has been added for bug 4758902
6792: BEGIN
6793: SELECT transaction_phase_code
6794: INTO l_transaction_phase_code
6795: FROM oe_order_lines_all
6796: WHERE line_id = p_x_line_tbl(I).line_id;
6797: EXCEPTION
6798: WHEN NO_DATA_FOUND THEN
6799: oe_debug_pub.add(' No Transaction Phase Code for parent split line.',1);