APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on OE_ORDER_LINES_ALL

Line 4744: FROM oe_order_lines_all

4740: ELSIF (p_location_source_table = 'IN_TRANSIT') THEN
4741: BEGIN
4742: SELECT '1'
4743: INTO l_temp_id
4744: FROM oe_order_lines_all
4745: WHERE line_id = p_sales_ord_line_id;
4746:
4747: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4748: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND

Line 5472: ,oe_order_lines_all line

5468: Begin
5469: select hdr.order_number,line.line_number
5470: into l_order_number,l_line_number
5471: from oe_order_headers_all hdr
5472: ,oe_order_lines_all line
5473: where line.line_id = l_src_txn_id
5474: and hdr.header_id = line.header_id;
5475: Exception
5476: when no_data_found then

Line 6144: IF tld_rec.source_transaction_table = 'OE_ORDER_LINES_ALL'

6140:
6141: FOR tld_rec IN tld_cur
6142: LOOP
6143: -- Start of Bug#12599234
6144: IF tld_rec.source_transaction_table = 'OE_ORDER_LINES_ALL'
6145: AND tld_rec.source_transaction_id IS NOT NULL THEN
6146: BEGIN
6147: select flow_status_code
6148: into l_oe_line_status

Line 6149: from OE_ORDER_LINES_ALL

6145: AND tld_rec.source_transaction_id IS NOT NULL THEN
6146: BEGIN
6147: select flow_status_code
6148: into l_oe_line_status
6149: from OE_ORDER_LINES_ALL
6150: where line_id = tld_rec.source_transaction_id;
6151:
6152: IF l_oe_line_status = 'CANCELLED' THEN
6153: -- OE line cancelled, so proceed with checking next OE line