DBA Data[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on WIP_LPN_COMPLETIONS

Line 519: FROM WIP_LPN_COMPLETIONS WLC,

515: WHERE ORGANIZATION_ID = p_organization_id
516: AND STATUS IN (1, 3)
517: UNION ALL
518: SELECT WLC.WIP_ENTITY_ID
519: FROM WIP_LPN_COMPLETIONS WLC,
520: WMS_LICENSE_PLATE_NUMBERS LPN ,
521: MTL_TXN_REQUEST_LINES MTRL
522: WHERE WLC.ORGANIZATION_ID = p_organization_id
523: AND WLC.LPN_ID = LPN.LPN_ID