3355: WHERE APPLICATION_ID = p_event_class_rec.application_id
3356: AND ENTITY_CODE = p_event_class_rec.entity_code
3357: AND EVENT_CLASS_CODE = p_event_class_rec.event_class_code
3358: AND TRX_ID = p_event_class_rec.trx_id
3359: AND EXISTS (SELECT /*+ INDEX(ZX_ITM_DISTRIBUTIONS_GT ZX_ITM_DISTRIBUTIONS_GT_U1
3360: ZX_ITM_DISTRIBUTIONS_GT_U1) */ 1
3361: FROM ZX_ITM_DISTRIBUTIONS_GT ZD
3362: WHERE ZL.APPLICATION_ID = ZD.APPLICATION_ID
3363: AND ZL.ENTITY_CODE = ZD.ENTITY_CODE
3356: AND ENTITY_CODE = p_event_class_rec.entity_code
3357: AND EVENT_CLASS_CODE = p_event_class_rec.event_class_code
3358: AND TRX_ID = p_event_class_rec.trx_id
3359: AND EXISTS (SELECT /*+ INDEX(ZX_ITM_DISTRIBUTIONS_GT ZX_ITM_DISTRIBUTIONS_GT_U1
3360: ZX_ITM_DISTRIBUTIONS_GT_U1) */ 1
3361: FROM ZX_ITM_DISTRIBUTIONS_GT ZD
3362: WHERE ZL.APPLICATION_ID = ZD.APPLICATION_ID
3363: AND ZL.ENTITY_CODE = ZD.ENTITY_CODE
3364: AND ZL.EVENT_CLASS_CODE = ZD.EVENT_CLASS_CODE
3357: AND EVENT_CLASS_CODE = p_event_class_rec.event_class_code
3358: AND TRX_ID = p_event_class_rec.trx_id
3359: AND EXISTS (SELECT /*+ INDEX(ZX_ITM_DISTRIBUTIONS_GT ZX_ITM_DISTRIBUTIONS_GT_U1
3360: ZX_ITM_DISTRIBUTIONS_GT_U1) */ 1
3361: FROM ZX_ITM_DISTRIBUTIONS_GT ZD
3362: WHERE ZL.APPLICATION_ID = ZD.APPLICATION_ID
3363: AND ZL.ENTITY_CODE = ZD.ENTITY_CODE
3364: AND ZL.EVENT_CLASS_CODE = ZD.EVENT_CLASS_CODE
3365: AND ZL.TRX_ID = ZD.TRX_ID