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_MIGRATE_TAX_DEF dependencies on AP_TAX_RECVRY_RATES_ALL

Line 5943: ap_tax_recvry_rates_all rates

5939: FROM
5940: ap_tax_codes_all codes,
5941: zx_rates_b zx_rates,
5942: ap_tax_recvry_rules_all rules,
5943: ap_tax_recvry_rates_all rates
5944: WHERE
5945: codes.tax_recovery_rule_id = rules.rule_id
5946: AND rules.rule_id = rates.rule_id
5947: --Added following conditions for Sync process

Line 9075: ap_tax_recvry_rates_all RATES

9071: RATES.CONCATENATED_SEGMENT_HIGH VALUE_HIGH
9072:
9073: FROM
9074: ap_tax_recvry_rules_all RULES,
9075: ap_tax_recvry_rates_all RATES
9076: WHERE
9077: RULES.rule_id = rates.rule_id
9078: --Added following conditions for Sync process
9079: AND rates.rate_id = nvl(p_rate_id,rates.rate_id)

Line 9102: ap_tax_recvry_rates_all RATES

9098: NULL VALUE_LOW ,
9099: NULL VALUE_HIGH
9100: FROM
9101: ap_tax_recvry_rules_all RULES,
9102: ap_tax_recvry_rates_all RATES
9103: WHERE
9104: RULES.rule_id = rates.rule_id
9105: --Added following conditions for Sync process
9106: AND rates.rate_id = nvl(p_rate_id,rates.rate_id)

Line 9219: ap_tax_recvry_rates_all RATES

9215: ap_tax_recvry_rules_all RULES,
9216: --ap_system_parameters_all ASP,
9217: gl_sets_of_books SOB,
9218: financials_system_params_all FSP,
9219: ap_tax_recvry_rates_all RATES
9220: WHERE
9221: rules.org_id = fsp.org_id
9222: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
9223: AND RULES.RULE_ID = RATES.RULE_ID

Line 9240: ap_tax_recvry_rates_all RATES1

9236: RULES1.RULE_ID,
9237: RATES1.RATE_ID
9238: FROM
9239: ap_tax_recvry_rules_all RULES1,
9240: ap_tax_recvry_rates_all RATES1
9241: WHERE
9242: RULES1.rule_id = RATES1.rule_id
9243: ) TEMP_GROUPS
9244: WHERE

Line 9351: ap_tax_recvry_rates_all RATES

9347: ap_tax_recvry_rules_all RULES,
9348: --ap_system_parameters_all ASP,
9349: gl_sets_of_books SOB,
9350: financials_system_params_all FSP,
9351: ap_tax_recvry_rates_all RATES
9352: WHERE
9353: rules.org_id = fsp.org_id
9354: AND rules.org_id = l_org_id
9355: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID

Line 9373: ap_tax_recvry_rates_all RATES1

9369: RULES1.RULE_ID,
9370: RATES1.RATE_ID
9371: FROM
9372: ap_tax_recvry_rules_all RULES1,
9373: ap_tax_recvry_rates_all RATES1
9374: WHERE
9375: RULES1.rule_id = RATES1.rule_id
9376: ) TEMP_GROUPS
9377: WHERE

Line 9489: ap_tax_recvry_rates_all RATES

9485: ap_tax_recvry_rules_all RULES,
9486: --ap_system_parameters_all ASP,
9487: gl_sets_of_books SOB,
9488: financials_system_params_all FSP,
9489: ap_tax_recvry_rates_all RATES
9490: WHERE
9491: rules.org_id = fsp.org_id
9492: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID
9493: AND RULES.RULE_ID = RATES.RULE_ID

Line 9510: ap_tax_recvry_rates_all RATES1

9506: RULES1.RULE_ID,
9507: RATES1.RATE_ID
9508: FROM
9509: ap_tax_recvry_rules_all RULES1,
9510: ap_tax_recvry_rates_all RATES1
9511: WHERE
9512: RULES1.rule_id = RATES1.rule_id
9513: ) TEMP_GROUPS
9514: WHERE

Line 9623: ap_tax_recvry_rates_all RATES

9619: ap_tax_recvry_rules_all RULES,
9620: --ap_system_parameters_all ASP,
9621: gl_sets_of_books SOB,
9622: financials_system_params_all FSP,
9623: ap_tax_recvry_rates_all RATES
9624: WHERE
9625: rules.org_id = fsp.org_id
9626: AND rules.org_id = l_org_id
9627: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID

Line 9645: ap_tax_recvry_rates_all RATES1

9641: RULES1.RULE_ID,
9642: RATES1.RATE_ID
9643: FROM
9644: ap_tax_recvry_rules_all RULES1,
9645: ap_tax_recvry_rates_all RATES1
9646: WHERE
9647: RULES1.rule_id = RATES1.rule_id
9648: ) TEMP_GROUPS
9649: WHERE

Line 9826: from ap_tax_recvry_rates_all

9822: END TAX_RULE_CODE,
9823: RATES.TAX TAX ,
9824: RATES.TAX_REGIME_CODE TAX_REGIME_CODE,
9825: (select min(start_date)
9826: from ap_tax_recvry_rates_all
9827: where rule_id = RULES.rule_id) EFFECTIVE_FROM,
9828: ptp.party_tax_profile_id CONTENT_OWNER_ID
9829: FROM
9830: ap_tax_codes_all codes,

Line 9939: from ap_tax_recvry_rates_all

9935: END TAX_RULE_CODE,
9936: RATES.TAX TAX,
9937: RATES.TAX_REGIME_CODE TAX_REGIME_CODE,
9938: (select min(start_date)
9939: from ap_tax_recvry_rates_all
9940: where rule_id = RULES.rule_id) EFFECTIVE_FROM,
9941: ptp.party_tax_profile_id CONTENT_OWNER_ID
9942: FROM
9943: ap_tax_codes_all codes,

Line 10123: ap_tax_recvry_rates_all AP_RATES,

10119: END ENABLED_FLAG --ENABLED_FLAG
10120: FROM
10121: AP_TAX_CODES_ALL CODES,
10122: ap_tax_recvry_rules_all AP_RULES,
10123: ap_tax_recvry_rates_all AP_RATES,
10124: ZX_RATES_B ZX_RATES,
10125: ZX_RULES_B ZX_RULES,
10126: ZX_CONDITION_GROUPS_B GROUPS,
10127: zx_party_tax_profile ptp

Line 10167: ap_tax_recvry_rates_all RATES1

10163: RULES1.RULE_ID,
10164: RATES1.RATE_ID
10165: FROM
10166: ap_tax_recvry_rules_all RULES1,
10167: ap_tax_recvry_rates_all RATES1
10168: WHERE
10169: RULES1.rule_id = RATES1.rule_id
10170: ) TEMP_GROUPS
10171: WHERE

Line 10279: ap_tax_recvry_rates_all AP_RATES,

10275: END ENABLED_FLAG --ENABLED_FLAG
10276: FROM
10277: AP_TAX_CODES_ALL CODES,
10278: ap_tax_recvry_rules_all AP_RULES,
10279: ap_tax_recvry_rates_all AP_RATES,
10280: ZX_RATES_B ZX_RATES,
10281: ZX_RULES_B ZX_RULES,
10282: ZX_CONDITION_GROUPS_B GROUPS,
10283: zx_party_tax_profile ptp

Line 10324: ap_tax_recvry_rates_all RATES1

10320: RULES1.RULE_ID,
10321: RATES1.RATE_ID
10322: FROM
10323: ap_tax_recvry_rules_all RULES1,
10324: ap_tax_recvry_rates_all RATES1
10325: WHERE
10326: RULES1.rule_id = RATES1.rule_id
10327: ) TEMP_GROUPS
10328: WHERE