DBA Data[Home] [Help]

APPS.OE_PROCESS_REQUISITION_PVT dependencies on OE_ORDER_LINES_ALL

Line 627: from oe_order_lines_all

623: l_req_can_qty2_tbl Dbms_Sql.number_table; --Bug 14211120 Secondary cancel qty
624:
625: CURSOR Cancel_Lines IS
626: select source_document_line_id
627: from oe_order_lines_all
628: where header_id = p_header_id
629: and open_flag = 'N'
630: and nvl(cancelled_flag, 'N') = 'Y'; -- Cursor added for 8583903
631: --

Line 768: from oe_order_lines_all

764: , last_update_date
765: into g_sales_ord_line_num
766: , g_ISO_cancelled_quantity
767: , g_line_cancellation_date
768: from oe_order_lines_all
769: where line_id = p_line_id;
770:
771: select items.concatenated_segments
772: , prl.line_num

Line 864: from oe_order_lines_all

860: -- , g_updated_quantity
861: , g_schedule_ship_date
862: , g_schedule_arrival_date
863: , g_line_updated_date
864: from oe_order_lines_all
865: where line_id = p_line_id;
866:
867:
868: select items.concatenated_segments