DBA Data[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on MTL_TXN_REQUEST_LINES

Line 502: FROM MTL_TXN_REQUEST_LINES

498: WHERE ORGANIZATION_ID = p_organization_id
499: AND TRANSACTION_SOURCE_TYPE_ID = 5
500: AND TRANSACTION_SOURCE_ID NOT IN
501: (SELECT TXN_SOURCE_ID
502: FROM MTL_TXN_REQUEST_LINES
503: WHERE TXN_SOURCE_ID = MMTT.TRANSACTION_SOURCE_ID
504: AND ORGANIZATION_ID = MMTT.ORGANIZATION_ID
505: AND LINE_STATUS = 9)
506: UNION ALL

Line 521: MTL_TXN_REQUEST_LINES MTRL

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
524: AND MTRL.LPN_ID = LPN.LPN_ID
525: AND MTRL.txn_source_id = WLC.wip_entity_id