DBA Data[Home] [Help]

APPS.ZX_TRL_MANAGE_TAX_PKG dependencies on ZX_ITM_DISTRIBUTIONS_GT

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

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

Line 3360: ZX_ITM_DISTRIBUTIONS_GT_U1) */ 1

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

Line 3361: FROM ZX_ITM_DISTRIBUTIONS_GT ZD

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