eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_VALIDATE_API_PKG dependencies on ZX_RATES_B

Line 556: ZX_RATES_B rates,

552: FROM ZX_FC_COUNTRY_DEFAULTS ContDef,
553: ZX_IMPORT_TAX_LINES_GT TaxLines_gt,
554: ZX_TRX_HEADERS_GT Header,
555: ZX_TRANSACTION_LINES_GT Lines,
556: ZX_RATES_B rates,
557: ZX_SUBSCRIPTION_DETAILS sd_rates
558: WHERE TaxLines_gt.tax_rate_code = rates.tax_rate_code(+)
559: AND (Taxlines_gt.tax_rate_code IS NOT NULL OR Taxlines_gt.tax_rate_id IS NOT NULL)
560: AND lines.tax_date --Bug 5018766

Line 625: FROM zx_rates_b

621: AND NVL(sd_rates.effective_to,
622: lines.subscription_date)
623: OR
624: Rates.effective_from = (SELECT MIN(effective_from)
625: FROM zx_rates_b
626: WHERE
627: tax_regime_code = Rates.tax_regime_code and
628: tax = Rates.tax and
629: tax_status_code = Rates.tax_status_code and

Line 637: AND NOT EXISTS (SELECT 1 FROM zx_rates_b b

633: )
634: )
635: AND (NVL(sd_rates.view_options_code,'NONE') in ('NONE', 'VFC') OR
636: (NVL(sd_rates.view_options_code, 'VFR') = 'VFR'
637: AND NOT EXISTS (SELECT 1 FROM zx_rates_b b
638: WHERE b.tax_regime_code = Rates.tax_regime_code
639: AND b.tax = Rates.tax
640: AND b.tax_status_code = Rates.tax_status_code
641: AND b.tax_rate_code = Rates.tax_rate_code

Line 673: ZX_RATES_B rates,

669: FROM ZX_FC_COUNTRY_DEFAULTS ContDef,
670: ZX_IMPORT_TAX_LINES_GT TaxLines_gt,
671: ZX_TRX_HEADERS_GT Header,
672: ZX_TRANSACTION_LINES_GT Lines,
673: ZX_RATES_B rates,
674: ZX_SUBSCRIPTION_DETAILS sd_rates
675: WHERE TaxLines_gt.tax_rate_id = rates.tax_rate_id(+)
676: AND (Taxlines_gt.tax_rate_code IS NOT NULL OR Taxlines_gt.tax_rate_id IS NOT NULL)
677: AND lines.tax_date --Bug 5018766

Line 742: FROM zx_rates_b

738: AND NVL(sd_rates.effective_to,
739: lines.subscription_date)
740: OR
741: Rates.effective_from = (SELECT MIN(effective_from)
742: FROM zx_rates_b
743: WHERE
744: tax_regime_code = Rates.tax_regime_code and
745: tax = Rates.tax and
746: tax_status_code = Rates.tax_status_code and

Line 754: AND NOT EXISTS (SELECT 1 FROM zx_rates_b b

750: )
751: )
752: AND (NVL(sd_rates.view_options_code,'NONE') in ('NONE', 'VFC') OR
753: (NVL(sd_rates.view_options_code, 'VFR') = 'VFR'
754: AND NOT EXISTS (SELECT 1 FROM zx_rates_b b
755: WHERE b.tax_regime_code = Rates.tax_regime_code
756: AND b.tax = Rates.tax
757: AND b.tax_status_code = Rates.tax_status_code
758: AND b.tax_rate_code = Rates.tax_rate_code

Line 789: ZX_RATES_B rates,

785: FROM ZX_STATUS_B Status,
786: ZX_TRX_HEADERS_GT Header,
787: ZX_TRANSACTION_LINES_GT Lines,
788: ZX_SUBSCRIPTION_DETAILS sd_status,
789: ZX_RATES_B rates,
790: ZX_SUBSCRIPTION_DETAILS sd_rates
791: WHERE Status.tax_regime_code = TaxLines.tax_regime_code
792: AND Status.tax = TaxLines.tax
793: --AND Status.default_status_flag = 'Y'

Line 888: FROM zx_rates_b

884: AND NVL(sd_rates.effective_to,
885: lines.subscription_date)
886: OR
887: Rates.effective_from = (SELECT MIN(effective_from)
888: FROM zx_rates_b
889: WHERE
890: tax_regime_code = Rates.tax_regime_code and
891: tax = Rates.tax and
892: tax_status_code = Rates.tax_status_code and

Line 900: AND NOT EXISTS (SELECT 1 FROM zx_rates_b b

896: )
897: )
898: AND (NVL(sd_rates.view_options_code,'NONE') in ('NONE', 'VFC') OR
899: (NVL(sd_rates.view_options_code, 'VFR') = 'VFR'
900: AND NOT EXISTS (SELECT 1 FROM zx_rates_b b
901: WHERE b.tax_regime_code = Rates.tax_regime_code
902: AND b.tax = Rates.tax
903: AND b.tax_status_code = Rates.tax_status_code
904: AND b.tax_rate_code = Rates.tax_rate_code

Line 1017: ZX_RATES_B rates,

1013: (SELECT jur.TAX_JURISDICTION_CODE
1014: FROM ZX_JURISDICTIONS_B Jur,
1015: ZX_TRX_HEADERS_GT Header,
1016: ZX_TRANSACTION_LINES_GT Lines,
1017: ZX_RATES_B rates,
1018: ZX_SUBSCRIPTION_DETAILS sd_rates
1019: WHERE
1020: Jur.tax = TaxLines.Tax
1021: AND Jur.tax_regime_code = TaxLines.Tax_Regime_Code

Line 1092: FROM zx_rates_b

1088: AND NVL(sd_rates.effective_to,
1089: lines.subscription_date)
1090: OR
1091: Rates.effective_from = (SELECT MIN(effective_from)
1092: FROM zx_rates_b
1093: WHERE
1094: tax_regime_code = Rates.tax_regime_code and
1095: tax = Rates.tax and
1096: tax_status_code = Rates.tax_status_code and

Line 1103: AND NOT EXISTS (SELECT 1 FROM zx_rates_b b

1099: )
1100: )
1101: AND (NVL(sd_rates.view_options_code,'NONE') in ('NONE', 'VFC') OR
1102: (NVL(sd_rates.view_options_code, 'VFR') = 'VFR'
1103: AND NOT EXISTS (SELECT 1 FROM zx_rates_b b
1104: WHERE b.tax_regime_code = Rates.tax_regime_code
1105: AND b.tax = Rates.tax
1106: AND b.tax_status_code = Rates.tax_status_code
1107: AND b.tax_rate_code = Rates.tax_rate_code

Line 1144: FROM zx_rates_b rates,

1140: TaxLines.entity_code entity_code,
1141: TaxLines.event_class_code event_class_code,
1142: TaxLines.trx_id trx_id,
1143: TaxLines.summary_tax_line_number summary_tax_line_number
1144: FROM zx_rates_b rates,
1145: zx_trx_headers_gt header,
1146: zx_transaction_lines_gt lines,
1147: zx_subscription_details sd_rates,
1148: zx_import_tax_lines_gt taxlines

Line 1183: FROM zx_rates_b

1179: BETWEEN NVL(sd_rates.effective_from,lines.subscription_date)
1180: AND NVL(sd_rates.effective_to,lines.subscription_date)
1181: OR
1182: Rates.effective_from = (SELECT MIN(effective_from)
1183: FROM zx_rates_b
1184: WHERE tax_regime_code = Rates.tax_regime_code
1185: and tax = Rates.tax
1186: and tax_status_code = Rates.tax_status_code
1187: and tax_rate_code = Rates.tax_rate_code

Line 1195: AND NOT EXISTS (SELECT 1 FROM zx_rates_b b

1191: )
1192: AND ( NVL(sd_rates.view_options_code,'NONE') in ('NONE', 'VFC')
1193: OR
1194: (NVL(sd_rates.view_options_code, 'VFR') = 'VFR'
1195: AND NOT EXISTS (SELECT 1 FROM zx_rates_b b
1196: WHERE b.tax_regime_code = Rates.tax_regime_code
1197: AND b.tax = Rates.tax
1198: AND b.tax_status_code = Rates.tax_status_code
1199: AND b.tax_rate_code = Rates.tax_rate_code

Line 1247: SELECT /+ index(rates ZX_RATES_B_U2) /

1243: )
1244: -- debug for bug 7414628 added UNION ALL by splitting the code for the join
1245: -- AND (Taxlines.tax_rate_code = rates.tax_rate_code OR Taxlines.tax_rate_id = rates.tax_rate_id)
1246: UNION ALL
1247: SELECT /*+ index(rates ZX_RATES_B_U2) */
1248: NVL(taxlines.tax_rate_code,Rates.tax_rate_code) rate_code,
1249: NVL(taxlines.tax_rate_id,Rates.tax_rate_id) rate_id,
1250: NVL(taxlines.tax_rate,Rates.percentage_rate) percnt_rate,
1251: TaxLines.application_id application_id,

Line 1256: FROM zx_rates_b rates,

1252: TaxLines.entity_code entity_code,
1253: TaxLines.event_class_code event_class_code,
1254: TaxLines.trx_id trx_id,
1255: TaxLines.summary_tax_line_number summary_tax_line_number
1256: FROM zx_rates_b rates,
1257: zx_trx_headers_gt header,
1258: zx_transaction_lines_gt lines,
1259: zx_subscription_details sd_rates,
1260: zx_import_tax_lines_gt taxlines

Line 1295: FROM zx_rates_b

1291: BETWEEN NVL(sd_rates.effective_from,lines.subscription_date)
1292: AND NVL(sd_rates.effective_to,lines.subscription_date)
1293: OR
1294: Rates.effective_from = (SELECT MIN(effective_from)
1295: FROM zx_rates_b
1296: WHERE tax_regime_code = Rates.tax_regime_code
1297: and tax = Rates.tax
1298: and tax_status_code = Rates.tax_status_code
1299: and tax_rate_code = Rates.tax_rate_code

Line 1307: AND NOT EXISTS (SELECT 1 FROM zx_rates_b b

1303: )
1304: AND ( NVL(sd_rates.view_options_code,'NONE') in ('NONE', 'VFC')
1305: OR
1306: (NVL(sd_rates.view_options_code, 'VFR') = 'VFR'
1307: AND NOT EXISTS (SELECT 1 FROM zx_rates_b b
1308: WHERE b.tax_regime_code = Rates.tax_regime_code
1309: AND b.tax = Rates.tax
1310: AND b.tax_status_code = Rates.tax_status_code
1311: AND b.tax_rate_code = Rates.tax_rate_code

Line 1417: zx_rates_b rate,

1413: ZX_IMPORT_TAX_LINES_GT TaxLines,
1414: ZX_TRX_HEADERS_GT Header,
1415: ZX_TRANSACTION_LINES_GT Lines,
1416: ZX_TAXES_B tax,
1417: zx_rates_b rate,
1418: zx_subscription_details sd_tax,
1419: zx_subscription_details sd_rates
1420: WHERE Taxlines.TAX_LINE_ALLOCATION_FLAG = 'Y'
1421: AND TaxLines.tax_amt is NULL

Line 1542: from ZX_RATES_B

1538: header.trx_date,
1539: SYSDATE) )
1540: OR
1541: rate.effective_from = (select min(effective_from)
1542: from ZX_RATES_B
1543: where
1544: tax_regime_code = rate.tax_regime_code and
1545: tax = rate.tax and
1546: tax_status_code = rate.tax_status_code and

Line 1553: AND NOT EXISTS (select 1 from zx_rates_b b

1549: )
1550: )
1551: AND (NVL(sd_rates.view_options_code,'NONE') in ('NONE', 'VFC') OR
1552: (NVL(sd_rates.view_options_code, 'VFR') = 'VFR'
1553: AND NOT EXISTS (select 1 from zx_rates_b b
1554: where b.tax_regime_code = rate.tax_regime_code
1555: and b.tax = rate.tax
1556: and b.tax_status_code = rate.tax_status_code
1557: and b.tax_rate_code = rate.tax_rate_code

Line 1634: --ZX_RATES_B rates --Commented for Bug#7504455--

1630: ZX_FC_CODES_B fc_int,
1631: FND_LOOKUPS fnd,
1632: FND_TERRITORIES fnd_terr,
1633: ZX_FC_PRODUCT_FISCAL_V fc_product
1634: --ZX_RATES_B rates --Commented for Bug#7504455--
1635:
1636: WHERE
1637: lines_gt.trx_id = header.trx_id
1638: and fc_product.classification_code(+) =

Line 1679: -- ZX_RATES_B rate ,

1675: FROM ZX_TRX_HEADERS_GT header,
1676: ZX_REGIMES_B regime ,
1677: ZX_TAXES_B tax ,
1678: ZX_STATUS_B status ,
1679: -- ZX_RATES_B rate ,
1680: -- zx_rates_b off_rate,
1681: -- zx_import_tax_lines_gt temp_gt,
1682: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
1683: zx_transaction_lines_gt lines_gt,

Line 1680: -- zx_rates_b off_rate,

1676: ZX_REGIMES_B regime ,
1677: ZX_TAXES_B tax ,
1678: ZX_STATUS_B status ,
1679: -- ZX_RATES_B rate ,
1680: -- zx_rates_b off_rate,
1681: -- zx_import_tax_lines_gt temp_gt,
1682: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
1683: zx_transaction_lines_gt lines_gt,
1684: ZX_JURISDICTIONS_B jur,

Line 4042: FROM zx_rates_b rates,

4038: /* CASE WHEN ((lines_gt.output_tax_classification_code IS NOT NULL OR
4039: lines_gt.input_tax_classification_code IS NOT NULL)
4040: --Changed for Bug#7504455--
4041: AND NOT EXISTS (SELECT 1
4042: FROM zx_rates_b rates,
4043: zx_subscription_details zxsd
4044: WHERE rates.tax_rate_code = NVL(lines_gt.output_tax_classification_code,
4045: lines_gt.input_tax_classification_code)
4046: AND rates.tax_regime_code = zxsd.tax_regime_code

Line 4058: AND tax IN (SELECT tax FROM ZX_RATES_B

4054: /*CASE WHEN /*(lines_gt.output_tax_classification_code IS NOT NULL OR
4055: lines_gt.input_tax_classification_code IS NOT NULL)
4056: AND (EXISTS (SELECT 1 FROM ZX_TAXES_B
4057: WHERE TAX_TYPE_CODE = 'OFFSET'
4058: AND tax IN (SELECT tax FROM ZX_RATES_B
4059: WHERE tax_rate_code = NVL(lines_gt.output_tax_classification_code,
4060: lines_gt.input_tax_classification_code)))
4061: OR
4062: rates.rate_type_code = 'RECOVERY'

Line 4072: FROM zx_rates_b rates,

4068: CASE WHEN ((lines_gt.output_tax_classification_code IS NOT NULL OR
4069: lines_gt.input_tax_classification_code IS NOT NULL) AND
4070: --Changed for Bug#7504455--
4071: NOT EXISTS (SELECT 1
4072: FROM zx_rates_b rates,
4073: zx_subscription_details zxsd
4074: WHERE rates.tax_rate_code = NVL(lines_gt.output_tax_classification_code,
4075: lines_gt.input_tax_classification_code)
4076: AND rates.tax_regime_code = zxsd.tax_regime_code

Line 4089: FROM zx_rates_b rates,

4085: CASE WHEN ((lines_gt.output_tax_classification_code IS NOT NULL OR
4086: lines_gt.input_tax_classification_code IS NOT NULL) AND
4087: --Changed for Bug#7504455--
4088: NOT EXISTS (SELECT 1
4089: FROM zx_rates_b rates,
4090: zx_subscription_details zxsd
4091: WHERE rates.tax_rate_code = NVL(lines_gt.output_tax_classification_code,
4092: lines_gt.input_tax_classification_code)
4093: AND rates.tax_regime_code = zxsd.tax_regime_code

Line 4165: --ZX_RATES_B rates --Commented for Bug#7504455--

4161: ZX_FC_BUSINESS_CATEGORIES_V fc_trx,
4162: ZX_FC_CODES_B fc_int,
4163: FND_LOOKUPS fnd,
4164: ZX_FC_PRODUCT_FISCAL_V fc_product
4165: --ZX_RATES_B rates --Commented for Bug#7504455--
4166: WHERE
4167: lines_gt.trx_id = header.trx_id
4168: and fc_product.classification_code(+) = lines_gt.product_fisc_classification
4169: and fc_prodcat.classification_code(+) = lines_gt.product_category

Line 5399: -- ZX_RATES_B rate ,

5395: FROM ZX_TRX_HEADERS_GT header,
5396: ZX_REGIMES_B regime ,
5397: ZX_TAXES_B tax ,
5398: ZX_STATUS_B status ,
5399: -- ZX_RATES_B rate ,
5400: -- zx_rates_b off_rate,
5401: -- zx_import_tax_lines_gt temp_gt,
5402: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
5403: zx_transaction_lines_gt lines_gt,

Line 5400: -- zx_rates_b off_rate,

5396: ZX_REGIMES_B regime ,
5397: ZX_TAXES_B tax ,
5398: ZX_STATUS_B status ,
5399: -- ZX_RATES_B rate ,
5400: -- zx_rates_b off_rate,
5401: -- zx_import_tax_lines_gt temp_gt,
5402: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
5403: zx_transaction_lines_gt lines_gt,
5404: ZX_JURISDICTIONS_B jur,

Line 6111: AND NOT EXISTS ( SELECT 1 FROM zx_rates_b

6107: --Bug 4703541
6108: CASE WHEN (sd_rates.tax_regime_code is not null and
6109: rate.tax_rate_code is not NULL )
6110: THEN CASE WHEN taxlines_gt.tax_rate_id IS NOT NULL
6111: AND NOT EXISTS ( SELECT 1 FROM zx_rates_b
6112: WHERE tax_rate_id = taxlines_gt.tax_rate_id)
6113: THEN 'Y'
6114: ELSE 'N' END
6115: ELSE 'Y' END TAX_RATE_CODE_NOT_EXISTS,

Line 6162: ZX_RATES_B rate ,

6158: ELSE 'Y' END
6159: ELSE NULL
6160: END DEFAULT_RATE_CODE_NOT_EXISTS
6161: FROM ZX_TRX_HEADERS_GT header,
6162: ZX_RATES_B rate ,
6163: zx_rates_b off_rate,
6164: zx_import_tax_lines_gt temp_gt,
6165: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
6166: zx_transaction_lines_gt lines_gt,

Line 6163: zx_rates_b off_rate,

6159: ELSE NULL
6160: END DEFAULT_RATE_CODE_NOT_EXISTS
6161: FROM ZX_TRX_HEADERS_GT header,
6162: ZX_RATES_B rate ,
6163: zx_rates_b off_rate,
6164: zx_import_tax_lines_gt temp_gt,
6165: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
6166: zx_transaction_lines_gt lines_gt,
6167: zx_subscription_details sd_rates

Line 6247: FROM ZX_RATES_B

6243: /* OR rate.effective_from =
6244: (
6245: SELECT
6246: min(effective_from)
6247: FROM ZX_RATES_B
6248: WHERE tax_regime_code = rate.tax_regime_code
6249: AND tax = rate.tax
6250: AND tax_status_code = rate.tax_status_code
6251: AND tax_rate_code = rate.tax_rate_code

Line 6265: FROM zx_rates_b b

6261: AND NOT EXISTS
6262: (
6263: SELECT
6264: 1
6265: FROM zx_rates_b b
6266: WHERE b.tax_regime_code = rate.tax_regime_code
6267: AND b.tax = rate.tax
6268: AND b.tax_status_code = rate.tax_status_code
6269: AND b.tax_rate_code = rate.tax_rate_code

Line 6405: AND NOT EXISTS ( SELECT 1 FROM zx_rates_b

6401: --Bug 4703541
6402: CASE WHEN ( sd_rates.tax_regime_code IS NOT NULL
6403: AND rate.tax_rate_id IS NOT NULL )
6404: THEN CASE WHEN taxlines_gt.tax_rate_code IS NOT NULL
6405: AND NOT EXISTS ( SELECT 1 FROM zx_rates_b
6406: WHERE tax_rate_code = taxlines_gt.tax_rate_code)
6407: THEN 'Y'
6408: ELSE 'N' END
6409: ELSE 'Y' END TAX_RATE_NOT_EXISTS,

Line 6422: ZX_RATES_B rate ,

6418: CASE WHEN rate.tax_rate_id IS NOT NULL AND rate.active_flag = 'Y'
6419: THEN 'N'
6420: ELSE 'Y' END TAX_RATE_NOT_ACTIVE
6421: FROM ZX_TRX_HEADERS_GT header,
6422: ZX_RATES_B rate ,
6423: zx_rates_b off_rate,
6424: zx_import_tax_lines_gt temp_gt,
6425: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
6426: zx_transaction_lines_gt lines_gt,

Line 6423: zx_rates_b off_rate,

6419: THEN 'N'
6420: ELSE 'Y' END TAX_RATE_NOT_ACTIVE
6421: FROM ZX_TRX_HEADERS_GT header,
6422: ZX_RATES_B rate ,
6423: zx_rates_b off_rate,
6424: zx_import_tax_lines_gt temp_gt,
6425: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
6426: zx_transaction_lines_gt lines_gt,
6427: zx_subscription_details sd_rates

Line 6506: FROM ZX_RATES_B

6502: /* OR rate.effective_from =
6503: (
6504: SELECT
6505: min(effective_from)
6506: FROM ZX_RATES_B
6507: WHERE tax_regime_code = rate.tax_regime_code
6508: AND tax = rate.tax
6509: AND tax_status_code = rate.tax_status_code
6510: AND tax_rate_code = rate.tax_rate_code

Line 6524: FROM zx_rates_b b

6520: AND NOT EXISTS
6521: (
6522: SELECT
6523: 1
6524: FROM zx_rates_b b
6525: WHERE b.tax_regime_code = rate.tax_regime_code
6526: AND b.tax = rate.tax
6527: AND b.tax_status_code = rate.tax_status_code
6528: AND b.tax_rate_code = rate.tax_rate_code