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
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
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