DBA Data[Home] [Help]

APPS.ZX_VALIDATE_API_PKG dependencies on ZX_EVNT_CLS_MAPPINGS

Line 929: ZX_EVNT_CLS_MAPPINGS mapp

925: FROM ZX_SRVC_SUBSCRIPTIONS srvc,
926: ZX_REGIMES_USAGES reg,
927: ZX_TRX_HEADERS_GT Header,
928: ZX_TRANSACTION_LINES_GT Lines,
929: ZX_EVNT_CLS_MAPPINGS mapp
930: WHERE reg.tax_regime_code = TaxLines.tax_regime_code
931: AND srvc.regime_usage_id = reg.regime_usage_id
932: AND srvc.enabled_flag = 'Y'
933: AND mapp.application_id = TaxLines.application_id

Line 1624: ZX_EVNT_CLS_MAPPINGS evntmap,

1620: lines_gt.trx_level_type
1621:
1622: FROM
1623: ZX_TRX_HEADERS_GT header,
1624: ZX_EVNT_CLS_MAPPINGS evntmap,
1625: ZX_TRANSACTION_LINES_GT lines_gt,
1626: ZX_FC_PRODUCT_CATEGORIES_V fc_prodcat,
1627: ZX_FC_CODES_B fc_user,
1628: ZX_FC_DOCUMENT_FISCAL_V fc_doc,

Line 2368: ZX_EVNT_CLS_MAPPINGS evntmap,

2364: ELSE NULL
2365: END ZX_DOC_LVL_RECALC_FLAG_INVALID
2366: FROM
2367: ZX_TRX_HEADERS_GT header,
2368: ZX_EVNT_CLS_MAPPINGS evntmap,
2369: ZX_FC_DOCUMENT_FISCAL_V fc_doc,
2370: FND_TERRITORIES fnd_terr
2371: WHERE
2372: fc_doc.classification_code(+) = header.document_sub_type

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

3934: THEN 'Y'
3935: ELSE NULL
3936: END ZX_LINE_CTRL_AMT_NOT_NULL,
3937:
3938: -- If tax_variance_calc_flag in ZX_EVNT_CLS_MAPPINGS is set to 'Y',
3939: -- then unit price and trx line quantity are required
3940: -- bugfix 4919842:
3941: -- unit price and trx line quantity are only required for non-amount based
3942: -- PO/receipt matched invoices

Line 4156: ZX_EVNT_CLS_MAPPINGS evntmap,

4152: ELSE NULL END
4153: END TAX_RATE_CODE_NOT_ACTIVE
4154: FROM
4155: ZX_TRX_HEADERS_GT header,
4156: ZX_EVNT_CLS_MAPPINGS evntmap,
4157: ZX_TRANSACTION_LINES_GT lines_gt,
4158: ZX_FC_PRODUCT_CATEGORIES_V fc_prodcat,
4159: ZX_FC_CODES_B fc_user,
4160: ZX_FC_DOCUMENT_FISCAL_V fc_doc,

Line 7265: ZX_EVNT_CLS_MAPPINGS map

7261: nvl2( lines_gt.source_trx_id,
7262: CASE WHEN ((NOT EXISTS
7263: (SELECT 1
7264: FROM ZX_LINES_DET_FACTORS line,
7265: ZX_EVNT_CLS_MAPPINGS map
7266: WHERE lines_gt.application_id = map.application_id
7267: AND lines_gt.entity_code = map.entity_code
7268: AND lines_gt.event_class_code = map.event_class_code
7269: AND line.application_id = decode(lines_gt.source_event_class_code,

Line 7287: zx_evnt_cls_mappings map

7283: AND line.trx_line_id = lines_gt.source_line_id
7284: AND line.trx_level_type = lines_gt.source_trx_level_type))
7285: AND ( NOT EXISTS
7286: (SELECT 1 FROM ZX_TRANSACTION_LINES_GT line,
7287: zx_evnt_cls_mappings map
7288: WHERE lines_gt.application_id = map.application_id
7289: AND lines_gt.entity_code = map.entity_code
7290: AND lines_gt.event_class_code = map.event_class_code
7291: AND line.application_id = decode(lines_gt.source_event_class_code,