APPS.OE_ORDER_PVT dependencies on OE_ORDER_LINES_ALL

Line 3950: FROM OE_ORDER_LINES_ALL

3946: source_document_line_id, orig_sys_shipment_ref
3947: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
3948: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
3949: l_source_document_line_id, l_orig_sys_shipment_ref
3950: FROM OE_ORDER_LINES_ALL
3951: WHERE line_id = l_line_Scredit_rec.line_id;
3952: EXCEPTION
3953: WHEN NO_DATA_FOUND THEN
3954: l_order_source_id := null;

Line 4001: FROM OE_ORDER_LINES_ALL

3997: source_document_line_id, orig_sys_shipment_ref
3998: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
3999: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
4000: l_source_document_line_id, l_orig_sys_shipment_ref
4001: FROM OE_ORDER_LINES_ALL
4002: WHERE line_id = l_old_line_Scredit_rec.line_id;
4003: EXCEPTION
4004: WHEN NO_DATA_FOUND THEN
4005: l_order_source_id := null;

Line 4532: FROM OE_ORDER_LINES_ALL

4528: source_document_line_id, orig_sys_shipment_ref
4529: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
4530: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
4531: l_source_document_line_id, l_orig_sys_shipment_ref
4532: FROM OE_ORDER_LINES_ALL
4533: WHERE line_id = l_line_Payment_rec.line_id;
4534: EXCEPTION
4535: WHEN NO_DATA_FOUND THEN
4536: l_order_source_id := null;

Line 4583: FROM OE_ORDER_LINES_ALL

4579: source_document_line_id, orig_sys_shipment_ref
4580: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
4581: l_source_document_type_id, l_source_document_id, l_orig_sys_line_ref,
4582: l_source_document_line_id, l_orig_sys_shipment_ref
4583: FROM OE_ORDER_LINES_ALL
4584: WHERE line_id = l_old_line_Payment_rec.line_id;
4585: EXCEPTION
4586: WHEN NO_DATA_FOUND THEN
4587: l_order_source_id := null;

Line 5982: FROM OE_ORDER_LINES_ALL

5978:
5979: BEGIN
5980: SELECT header_id
5981: INTO l_header_id
5982: FROM OE_ORDER_LINES_ALL
5983: WHERE line_id = l_line_id;
5984: EXCEPTION
5985: WHEN NO_DATA_FOUND THEN
5986: null;

Line 7016: FROM oe_order_lines_all

7012: -- Negotiation check has been added for bug 4758902
7013: BEGIN
7014: SELECT transaction_phase_code
7015: INTO l_transaction_phase_code
7016: FROM oe_order_lines_all
7017: WHERE line_id = p_x_line_tbl(I).line_id;
7018: EXCEPTION
7019: WHEN NO_DATA_FOUND THEN
7020: oe_debug_pub.add(' No Transaction Phase Code for parent split line.',1);