APPS.CSI_ITEM_INSTANCE_PVT dependencies on OE_ORDER_LINES_ALL

Line 2538: FROM oe_order_headers_all a, oe_order_lines_all b

2534: SELECT a.order_number,
2535: b.line_number
2536: INTO p_instance_header_tbl(tab_row).in_transit_order_number,
2537: p_instance_header_tbl(tab_row).in_transit_order_line_number
2538: FROM oe_order_headers_all a, oe_order_lines_all b
2539: WHERE a.header_id = b.header_id
2540: AND b.line_id = p_instance_header_tbl(tab_row).in_transit_order_line_id;
2541: EXCEPTION
2542: WHEN OTHERS THEN

Line 11053: from OE_ORDER_LINES_ALL

11049: Begin
11050: select NVL(actual_shipment_date,schedule_ship_date)
11051: ,org_id
11052: into l_order_shipped_date,l_order_org_id
11053: from OE_ORDER_LINES_ALL
11054: where line_id = p_oks_txn_inst_tbl(l_oks_txn_count).order_line_id;
11055: Exception -- Added exception handling for bug 6870487, in case the order line no longer exist in oe_order_lines_all table
11056: When no_data_found Then
11057: p_oks_txn_inst_tbl(l_oks_txn_count).order_line_id := NULL;

Line 11055: Exception -- Added exception handling for bug 6870487, in case the order line no longer exist in oe_order_lines_all table

11051: ,org_id
11052: into l_order_shipped_date,l_order_org_id
11053: from OE_ORDER_LINES_ALL
11054: where line_id = p_oks_txn_inst_tbl(l_oks_txn_count).order_line_id;
11055: Exception -- Added exception handling for bug 6870487, in case the order line no longer exist in oe_order_lines_all table
11056: When no_data_found Then
11057: p_oks_txn_inst_tbl(l_oks_txn_count).order_line_id := NULL;
11058: End;
11059: END IF;

Line 13926: FROM oe_order_lines_all

13922: agreement_id
13923: INTO p_instance_rec.last_oe_order_line_id,
13924: p_instance_rec.last_oe_rma_line_id,
13925: p_instance_rec.last_oe_agreement_id
13926: FROM oe_order_lines_all
13927: WHERE line_id = l_curr_instance_rec.in_transit_order_line_id;
13928: EXCEPTION
13929: WHEN OTHERS THEN
13930: NULL;

Line 34104: FROM oe_order_lines_all

34100: csi_gen_utility_pvt.put_line('Before link to line id ');
34101: BEGIN
34102: SELECT link_to_line_id, item_type_code
34103: INTO l_link_to_line_id, l_item_type_code
34104: FROM oe_order_lines_all
34105: WHERE line_id = l_new_instance_rec.last_oe_order_line_id;
34106: EXCEPTION
34107: WHEN OTHERS THEN
34108: l_link_to_line_id := null;