DBA Data[Home] [Help]

APPS.JL_ZZ_TAX_VALIDATE_PKG dependencies on ZX_EVNT_CLS_MAPPINGS

Line 150: zx_evnt_cls_mappings evntmap,

146: WHERE lines_gt.trx_business_category is NOT NULL
147: AND NOT EXISTS
148: (SELECT 1
149: FROM
150: zx_evnt_cls_mappings evntmap,
151: jl_zz_ar_tx_att_cls_all tac,
152: jl_zz_ar_tx_categ_all tc,
153: ar_system_parameters_all asp
154: where

Line 194: zx_evnt_cls_mappings evntmap,

190: AND NOT EXISTS
191: (
192: SELECT 1
193: FROM
194: zx_evnt_cls_mappings evntmap,
195: FND_LOOKUPS LK,
196: JL_ZZ_AR_TX_FSC_CLS FSC
197: where
198: lines_gt.application_id = evntmap.application_id

Line 550: ZX_EVNT_CLS_MAPPINGS event

546: Lines.trx_id
547: FROM
548: ZX_TRANSACTION_LINES_GT Lines ,
549: mtl_system_items items,
550: ZX_EVNT_CLS_MAPPINGS event
551: WHERE organization_id = l_organization_id
552: AND inventory_item_id = lines.product_id
553: AND lines.product_org_id is not NULL
554: AND Lines.application_id = Event.application_id

Line 577: ZX_EVNT_CLS_MAPPINGS event

573: Lines.trx_id
574: FROM
575: ZX_TRANSACTION_LINES_GT Lines ,
576: ar_memo_lines_all_b Memo,
577: ZX_EVNT_CLS_MAPPINGS event
578: WHERE Memo.memo_line_id = lines.product_id
579: AND lines.product_org_id is NULL
580: AND Lines.application_id = Event.application_id
581: AND Lines.entity_code = Event.entity_code

Line 1942: ZX_EVNT_CLS_MAPPINGS evntmap,

1938: END TAX_JUR_CODE_NA_FOR_LTE
1939:
1940: FROM
1941: ZX_TRX_HEADERS_GT header,
1942: ZX_EVNT_CLS_MAPPINGS evntmap,
1943: ZX_REGIMES_B regime ,
1944: ZX_TAXES_B tax ,
1945: ZX_STATUS_B status ,
1946: AR_VAT_TAX_ALL_B rate ,