DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_PVT dependencies on OE_ORDER_LINES_ALL

Line 3740: from OE_ORDER_LINES_ALL OEL

3736: End if;
3737: BEGIN
3738: select 1
3739: into l_same_doc
3740: from OE_ORDER_LINES_ALL OEL
3741: where OEL.LINE_ID = p_old_reference_id
3742: and OEL.HEADER_ID in ( select OEL1.HEADER_ID
3743: from OE_ORDER_LINES_ALL OEL1
3744: where OEL1.LINE_ID

Line 3743: from OE_ORDER_LINES_ALL OEL1

3739: into l_same_doc
3740: from OE_ORDER_LINES_ALL OEL
3741: where OEL.LINE_ID = p_old_reference_id
3742: and OEL.HEADER_ID in ( select OEL1.HEADER_ID
3743: from OE_ORDER_LINES_ALL OEL1
3744: where OEL1.LINE_ID
3745: = p_new_reference_id )
3746: and rownum < 2;
3747: l_progress := 'WMSINB-40408';

Line 4872: FROM oe_order_lines_all

4868: SELECT project_id,
4869: task_id -- bug 7218830
4870: INTO l_project_id
4871: , l_task_id
4872: FROM oe_order_lines_all
4873: WHERE line_id = p_oe_order_line_id;
4874: EXCEPTION
4875: WHEN no_data_found THEN
4876: l_project_id := NULL;