DBA Data[Home] [Help]

APPS.ZX_VALIDATE_API_PKG dependencies on ZX_EVNT_CLS_MAPPINGS

Line 1247: ZX_EVNT_CLS_MAPPINGS mapp

1243: FROM ZX_SRVC_SUBSCRIPTIONS srvc,
1244: ZX_REGIMES_USAGES reg,
1245: ZX_TRX_HEADERS_GT Header,
1246: --ZX_TRANSACTION_LINES_GT Lines,
1247: ZX_EVNT_CLS_MAPPINGS mapp
1248: WHERE reg.tax_regime_code = TaxLines.tax_regime_code
1249: AND srvc.regime_usage_id = reg.regime_usage_id
1250: AND srvc.enabled_flag = 'Y'
1251: AND mapp.application_id = TaxLines.application_id

Line 1969: ZX_EVNT_CLS_MAPPINGS evntmap,

1965: header.trx_id,
1966: lines_gt.trx_line_id,
1967: lines_gt.trx_level_type
1968: FROM ZX_TRX_HEADERS_GT header,
1969: ZX_EVNT_CLS_MAPPINGS evntmap,
1970: ZX_TRANSACTION_LINES_GT lines_gt,
1971: ZX_FC_PRODUCT_CATEGORIES_V fc_prodcat,
1972: ZX_FC_CODES_B fc_user,
1973: ZX_FC_DOCUMENT_FISCAL_V fc_doc,

Line 2660: ZX_EVNT_CLS_MAPPINGS evntmap,

2656: ELSE NULL
2657: END ZX_DOC_LVL_RECALC_FLAG_INVALID
2658: FROM
2659: ZX_TRX_HEADERS_GT header,
2660: ZX_EVNT_CLS_MAPPINGS evntmap,
2661: ZX_FC_DOCUMENT_FISCAL_V fc_doc,
2662: FND_TERRITORIES fnd_terr
2663: WHERE
2664: fc_doc.classification_code(+) = header.document_sub_type

Line 4399: -- If tax_variance_calc_flag in ZX_EVNT_CLS_MAPPINGS is set to 'Y',

4395: THEN 'Y'
4396: ELSE NULL
4397: END ZX_LINE_CTRL_AMT_NOT_NULL,
4398:
4399: -- If tax_variance_calc_flag in ZX_EVNT_CLS_MAPPINGS is set to 'Y',
4400: -- then unit price and trx line quantity are required
4401: -- bugfix 4919842:
4402: -- unit price and trx line quantity are only required for non-amount based
4403: -- PO/receipt matched invoices

Line 4657: ZX_EVNT_CLS_MAPPINGS evntmap,

4653: END
4654: END TAX_RATE_CODE_NOT_ACTIVE
4655: FROM
4656: ZX_TRX_HEADERS_GT header,
4657: ZX_EVNT_CLS_MAPPINGS evntmap,
4658: ZX_TRANSACTION_LINES_GT lines_gt,
4659: --ZX_FC_PRODUCT_CATEGORIES_V fc_prodcat,
4660: --ZX_FC_CODES_B fc_user,
4661: ZX_FC_DOCUMENT_FISCAL_V fc_doc,

Line 8948: ZX_EVNT_CLS_MAPPINGS map

8944: nvl2( lines_gt.source_trx_id,
8945: CASE WHEN ((NOT EXISTS
8946: (SELECT 1
8947: FROM ZX_LINES_DET_FACTORS line,
8948: ZX_EVNT_CLS_MAPPINGS map
8949: WHERE lines_gt.application_id = map.application_id
8950: AND lines_gt.entity_code = map.entity_code
8951: AND lines_gt.event_class_code = map.event_class_code
8952: AND line.application_id = decode(lines_gt.source_event_class_code,

Line 8971: zx_evnt_cls_mappings map

8967: AND line.trx_level_type = lines_gt.source_trx_level_type)
8968: )
8969: AND ( NOT EXISTS
8970: (SELECT 1 FROM ZX_TRANSACTION_LINES_GT line,
8971: zx_evnt_cls_mappings map
8972: WHERE lines_gt.application_id = map.application_id
8973: AND lines_gt.entity_code = map.entity_code
8974: AND lines_gt.event_class_code = map.event_class_code
8975: AND line.application_id = decode(lines_gt.source_event_class_code,