DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on OE_ORDER_LINES_ALL

Line 4658: FROM oe_order_lines_all

4654: ELSIF (p_location_source_table = 'IN_TRANSIT') THEN
4655: BEGIN
4656: SELECT '1'
4657: INTO l_temp_id
4658: FROM oe_order_lines_all
4659: WHERE line_id = p_sales_ord_line_id;
4660:
4661: IF ((p_project_id IS NULL) OR (p_project_id = FND_API.G_MISS_NUM)) AND
4662: ((p_task_id IS NULL) OR (p_task_id = FND_API.G_MISS_NUM)) AND

Line 5219: ,oe_order_lines_all line

5215: Begin
5216: select hdr.order_number,line.line_number
5217: into l_order_number,l_line_number
5218: from oe_order_headers_all hdr
5219: ,oe_order_lines_all line
5220: where line.line_id = l_src_txn_id
5221: and hdr.header_id = line.header_id;
5222: Exception
5223: when no_data_found then