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 7742: FROM oe_order_lines_all ool1,

7738: ELSE
7739: BEGIN
7740: SELECT 'Y'
7741: INTO l_exists
7742: FROM oe_order_lines_all ool1,
7743: oe_order_lines_all ool2
7744: WHERE ool1.header_id = ool2.header_id
7745: AND ool1.line_id = l_curr_instance_rec.LAST_OE_ORDER_LINE_ID
7746: AND ool2.line_id = p_instance_Rec.LAST_OE_ORDER_LINE_ID

Line 7743: oe_order_lines_all ool2

7739: BEGIN
7740: SELECT 'Y'
7741: INTO l_exists
7742: FROM oe_order_lines_all ool1,
7743: oe_order_lines_all ool2
7744: WHERE ool1.header_id = ool2.header_id
7745: AND ool1.line_id = l_curr_instance_rec.LAST_OE_ORDER_LINE_ID
7746: AND ool2.line_id = p_instance_Rec.LAST_OE_ORDER_LINE_ID
7747: AND ROWNUM = 1;

Line 11133: FROM oe_order_lines_all ool,

11129: BEGIN
11130: csi_gen_utility_pvt.put_line('l_exists : '||l_exists);
11131: SELECT 'Y'
11132: INTO l_exists
11133: FROM oe_order_lines_all ool,
11134: csi_transactions ct
11135: WHERE ool.line_id = l_instance_csr.last_oe_rma_line_id
11136: AND ct.transaction_id = p_transaction_id
11137: AND ool.header_id = ct.source_header_ref_id

Line 11342: from OE_ORDER_LINES_ALL

11338: Begin
11339: select NVL(actual_shipment_date,schedule_ship_date)
11340: ,org_id
11341: into l_order_shipped_date,l_order_org_id
11342: from OE_ORDER_LINES_ALL
11343: where line_id = p_oks_txn_inst_tbl(l_oks_txn_count).order_line_id;
11344: Exception -- Added exception handling for bug 6870487, in case the order line no longer exist in oe_order_lines_all table
11345: When no_data_found Then
11346: p_oks_txn_inst_tbl(l_oks_txn_count).order_line_id := NULL;

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

11340: ,org_id
11341: into l_order_shipped_date,l_order_org_id
11342: from OE_ORDER_LINES_ALL
11343: where line_id = p_oks_txn_inst_tbl(l_oks_txn_count).order_line_id;
11344: Exception -- Added exception handling for bug 6870487, in case the order line no longer exist in oe_order_lines_all table
11345: When no_data_found Then
11346: p_oks_txn_inst_tbl(l_oks_txn_count).order_line_id := NULL;
11347: End;
11348: END IF;

Line 14315: FROM oe_order_lines_all

14311: agreement_id
14312: INTO p_instance_rec.last_oe_order_line_id,
14313: p_instance_rec.last_oe_rma_line_id,
14314: p_instance_rec.last_oe_agreement_id
14315: FROM oe_order_lines_all
14316: WHERE line_id = l_curr_instance_rec.in_transit_order_line_id;
14317: EXCEPTION
14318: WHEN OTHERS THEN
14319: NULL;

Line 34747: FROM oe_order_lines_all

34743: csi_gen_utility_pvt.put_line('Before link to line id ');
34744: BEGIN
34745: SELECT link_to_line_id, item_type_code
34746: INTO l_link_to_line_id, l_item_type_code
34747: FROM oe_order_lines_all
34748: WHERE line_id = l_new_instance_rec.last_oe_order_line_id;
34749: EXCEPTION
34750: WHEN OTHERS THEN
34751: l_link_to_line_id := null;