APPS.OE_ORDER_PVT dependencies on OE_ORDER_LINES

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);

Line 11902: FROM oe_order_lines

11898: BEGIN
11899:
11900: SELECT ato_line_id
11901: INTO l_ato_line_id
11902: FROM oe_order_lines
11903: WHERE top_model_line_id
11904: = p_x_line_tbl(l_option_index).top_model_line_id
11905: AND component_code = l_component_code
11906: AND open_flag = 'Y';

Line 12025: FROM oe_order_lines

12021: ELSE
12022:
12023: SELECT ordered_quantity, component_sequence_id
12024: INTO l_model_quantity, l_model_seq_id
12025: FROM oe_order_lines
12026: WHERE line_id =
12027: p_x_line_tbl(l_option_index).top_model_line_id;
12028:
12029: