DBA Data[Home] [Help]

APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 749: FROM PO_REQUISITION_LINES_ALL PRL

745: ) /*ADDED AMOUNT condition for Bug7497877*/
746: AND nvl(pll.closed_code,'OPEN') not in ('FINALLY CLOSED', 'CLOSED') --Added CLOSED status:Bug#6142700
747: UNION ALL
748: SELECT 1
749: FROM PO_REQUISITION_LINES_ALL PRL
750: WHERE PRL.WIP_ENTITY_ID = l_wip_entity_id
751: AND PRL.DESTINATION_ORGANIZATION_ID = l_organization_id
752: AND nvl(PRL.cancel_flag, 'N') = 'N'
753: AND PRL.LINE_LOCATION_ID is NULL