DBA Data[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 167: WMS_LICENSE_PLATE_NUMBERS LPN,

163: bugs. */
164: AND NOT EXISTS
165: (SELECT 'X'
166: FROM WIP_LPN_COMPLETIONS WLC,
167: WMS_LICENSE_PLATE_NUMBERS LPN,
168: MTL_TXN_REQUEST_LINES MTRL
169: WHERE WLC.ORGANIZATION_ID = p_organization_id
170: AND WLC.LPN_ID = LPN.LPN_ID
171: AND MTRL.LPN_ID = LPN.LPN_ID

Line 787: WMS_LICENSE_PLATE_NUMBERS LPN ,

783: AND STATUS IN (1, 3)
784: UNION ALL
785: SELECT WLC.WIP_ENTITY_ID
786: FROM WIP_LPN_COMPLETIONS WLC,
787: WMS_LICENSE_PLATE_NUMBERS LPN ,
788: MTL_TXN_REQUEST_LINES MTRL
789: WHERE WLC.ORGANIZATION_ID = p_organization_id
790: AND WLC.LPN_ID = LPN.LPN_ID
791: AND MTRL.LPN_ID = LPN.LPN_ID