DBA Data[Home] [Help]

APPS.ZX_TRL_MANAGE_TAX_PKG dependencies on ZX_ITM_DISTRIBUTIONS_GT

Line 3625: AND EXISTS (SELECT /*+ INDEX(ZX_ITM_DISTRIBUTIONS_GT ZX_ITM_DISTRIBUTIONS_GT_U1

3621: WHERE APPLICATION_ID = p_event_class_rec.application_id
3622: AND ENTITY_CODE = p_event_class_rec.entity_code
3623: AND EVENT_CLASS_CODE = p_event_class_rec.event_class_code
3624: AND TRX_ID = p_event_class_rec.trx_id
3625: AND EXISTS (SELECT /*+ INDEX(ZX_ITM_DISTRIBUTIONS_GT ZX_ITM_DISTRIBUTIONS_GT_U1
3626: ZX_ITM_DISTRIBUTIONS_GT_U1) */ 1
3627: FROM ZX_ITM_DISTRIBUTIONS_GT ZD
3628: WHERE ZL.APPLICATION_ID = ZD.APPLICATION_ID
3629: AND ZL.ENTITY_CODE = ZD.ENTITY_CODE

Line 3626: ZX_ITM_DISTRIBUTIONS_GT_U1) */ 1

3622: AND ENTITY_CODE = p_event_class_rec.entity_code
3623: AND EVENT_CLASS_CODE = p_event_class_rec.event_class_code
3624: AND TRX_ID = p_event_class_rec.trx_id
3625: AND EXISTS (SELECT /*+ INDEX(ZX_ITM_DISTRIBUTIONS_GT ZX_ITM_DISTRIBUTIONS_GT_U1
3626: ZX_ITM_DISTRIBUTIONS_GT_U1) */ 1
3627: FROM ZX_ITM_DISTRIBUTIONS_GT ZD
3628: WHERE ZL.APPLICATION_ID = ZD.APPLICATION_ID
3629: AND ZL.ENTITY_CODE = ZD.ENTITY_CODE
3630: AND ZL.EVENT_CLASS_CODE = ZD.EVENT_CLASS_CODE

Line 3627: FROM ZX_ITM_DISTRIBUTIONS_GT ZD

3623: AND EVENT_CLASS_CODE = p_event_class_rec.event_class_code
3624: AND TRX_ID = p_event_class_rec.trx_id
3625: AND EXISTS (SELECT /*+ INDEX(ZX_ITM_DISTRIBUTIONS_GT ZX_ITM_DISTRIBUTIONS_GT_U1
3626: ZX_ITM_DISTRIBUTIONS_GT_U1) */ 1
3627: FROM ZX_ITM_DISTRIBUTIONS_GT ZD
3628: WHERE ZL.APPLICATION_ID = ZD.APPLICATION_ID
3629: AND ZL.ENTITY_CODE = ZD.ENTITY_CODE
3630: AND ZL.EVENT_CLASS_CODE = ZD.EVENT_CLASS_CODE
3631: AND ZL.TRX_ID = ZD.TRX_ID