DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_PVT dependencies on OE_ORDER_LINES_ALL

Line 3685: from OE_ORDER_LINES_ALL OEL

3681: End if;
3682: BEGIN
3683: select 1
3684: into l_same_doc
3685: from OE_ORDER_LINES_ALL OEL
3686: where OEL.LINE_ID = p_old_reference_id
3687: and OEL.HEADER_ID in ( select OEL1.HEADER_ID
3688: from OE_ORDER_LINES_ALL OEL1
3689: where OEL1.LINE_ID

Line 3688: from OE_ORDER_LINES_ALL OEL1

3684: into l_same_doc
3685: from OE_ORDER_LINES_ALL OEL
3686: where OEL.LINE_ID = p_old_reference_id
3687: and OEL.HEADER_ID in ( select OEL1.HEADER_ID
3688: from OE_ORDER_LINES_ALL OEL1
3689: where OEL1.LINE_ID
3690: = p_new_reference_id )
3691: and rownum < 2;
3692: l_progress := 'WMSINB-40408';

Line 4785: FROM oe_order_lines_all

4781: SELECT project_id,
4782: task_id -- bug 7218830
4783: INTO l_project_id
4784: , l_task_id
4785: FROM oe_order_lines_all
4786: WHERE line_id = p_oe_order_line_id;
4787: EXCEPTION
4788: WHEN no_data_found THEN
4789: l_project_id := NULL;