DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_PO_PKG dependencies on STANDARD

Line 1083: ,'STANDARD_TC' TAX_CALCULATION_FORMULA

1079: ,NULL TAX_APPLICABILITY_RESULT_ID
1080: ,'Y' TAX_APPORTIONMENT_FLAG
1081: ,1 TAX_APPORTIONMENT_LINE_NUMBER
1082: ,NULL TAX_BASE_MODIFIER_RATE
1083: ,'STANDARD_TC' TAX_CALCULATION_FORMULA
1084: ,NULL TAX_CODE
1085: ,taxes.tax_currency_code TAX_CURRENCY_CODE
1086: ,poh.rate_date TAX_CURRENCY_CONVERSION_DATE
1087: ,poh.rate TAX_CURRENCY_CONVERSION_RATE

Line 1129: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA

1125: ,NULL TAX_TYPE_CODE
1126: ,NULL TAXABLE_AMT
1127: ,NULL TAXABLE_AMT_FUNCL_CURR
1128: ,NULL TAXABLE_AMT_TAX_CURR
1129: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA
1130: ,NULL TAXING_JURIS_GEOGRAPHY_ID
1131: ,NULL THRESH_RESULT_ID
1132: ,NVL(poh.currency_code,
1133: poh.base_currency_code) TRX_CURRENCY_CODE

Line 1791: ,'STANDARD_TC' TAX_CALCULATION_FORMULA

1787: rates.tax_regime_code,
1788: rates.tax
1789: ORDER BY atg.tax_code_id) TAX_APPORTIONMENT_LINE_NUMBER
1790: ,NULL TAX_BASE_MODIFIER_RATE
1791: ,'STANDARD_TC' TAX_CALCULATION_FORMULA
1792: ,NULL TAX_CODE
1793: ,taxes.tax_currency_code TAX_CURRENCY_CODE
1794: ,poh.rate_date TAX_CURRENCY_CONVERSION_DATE
1795: ,poh.rate TAX_CURRENCY_CONVERSION_RATE

Line 1838: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA

1834: ,NULL TAX_TYPE_CODE
1835: ,NULL TAXABLE_AMT
1836: ,NULL TAXABLE_AMT_FUNCL_CURR
1837: ,NULL TAXABLE_AMT_TAX_CURR
1838: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA
1839: ,NULL TAXING_JURIS_GEOGRAPHY_ID
1840: ,NULL THRESH_RESULT_ID
1841: ,NVL(poh.currency_code,
1842: poh.base_currency_code) TRX_CURRENCY_CODE

Line 2263: 'STANDARD')) RECOVERY_TYPE_CODE

2259: -- End : Code changes for Bug#13955562 --
2260:
2261: ,DECODE(tmp.rec_flag,'N', NULL,
2262: NVL(rates.recovery_type_code,
2263: 'STANDARD')) RECOVERY_TYPE_CODE
2264: ,NULL RECOVERY_TYPE_ID
2265: ,NULL REF_DOC_CURR_CONV_RATE
2266: ,NULL REF_DOC_DIST_ID
2267: ,NULL REF_DOC_PER_UNIT_NREC_TAX_AMT

Line 2394: AND rates.recovery_type_code(+) = 'STANDARD'

2390: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
2391: AND rates.tax(+) = pohzd.tax
2392: AND rates.content_owner_id(+) = pohzd.content_owner_id
2393: AND rates.rate_type_code(+) = 'RECOVERY'
2394: AND rates.recovery_type_code(+) = 'STANDARD'
2395: AND rates.active_flag(+) = 'Y'
2396: AND rates.effective_from(+) <= sysdate
2397: --Bug 8724131
2398: --AND (rates.effective_to IS NULL OR rates.effective_to >= sysdate)

Line 3419: ,'STANDARD_TC' TAX_CALCULATION_FORMULA

3415: ,NULL TAX_APPLICABILITY_RESULT_ID
3416: ,'Y' TAX_APPORTIONMENT_FLAG
3417: ,1 TAX_APPORTIONMENT_LINE_NUMBER
3418: ,NULL TAX_BASE_MODIFIER_RATE
3419: ,'STANDARD_TC' TAX_CALCULATION_FORMULA
3420: ,NULL TAX_CODE
3421: ,taxes.tax_currency_code TAX_CURRENCY_CODE
3422: ,poll.poh_rate_date TAX_CURRENCY_CONVERSION_DATE
3423: ,poll.poh_rate TAX_CURRENCY_CONVERSION_RATE

Line 3465: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA

3461: ,NULL TAX_TYPE_CODE
3462: ,NULL TAXABLE_AMT
3463: ,NULL TAXABLE_AMT_FUNCL_CURR
3464: ,NULL TAXABLE_AMT_TAX_CURR
3465: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA
3466: ,NULL TAXING_JURIS_GEOGRAPHY_ID
3467: ,NULL THRESH_RESULT_ID
3468: ,NVL(poll.poh_currency_code,
3469: poll.aps_base_currency_code) TRX_CURRENCY_CODE

Line 4140: ,'STANDARD_TC' TAX_CALCULATION_FORMULA

4136: rates.tax_regime_code,
4137: rates.tax
4138: ORDER BY atg.tax_code_id) TAX_APPORTIONMENT_LINE_NUMBER
4139: ,NULL TAX_BASE_MODIFIER_RATE
4140: ,'STANDARD_TC' TAX_CALCULATION_FORMULA
4141: ,NULL TAX_CODE
4142: ,taxes.tax_currency_code TAX_CURRENCY_CODE
4143: ,poll.poh_rate_date TAX_CURRENCY_CONVERSION_DATE
4144: ,poll.poh_rate TAX_CURRENCY_CONVERSION_RATE

Line 4187: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA

4183: ,NULL TAX_TYPE_CODE
4184: ,NULL TAXABLE_AMT
4185: ,NULL TAXABLE_AMT_FUNCL_CURR
4186: ,NULL TAXABLE_AMT_TAX_CURR
4187: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA
4188: ,NULL TAXING_JURIS_GEOGRAPHY_ID
4189: ,NULL THRESH_RESULT_ID
4190: ,NVL(poll.poh_currency_code,
4191: poll.aps_base_currency_code) TRX_CURRENCY_CODE

Line 4624: 'STANDARD')) RECOVERY_TYPE_CODE

4620: -- End : Code changes for Bug#13955562 --
4621:
4622: ,DECODE(tmp.rec_flag,'N', NULL,
4623: NVL(rates.recovery_type_code,
4624: 'STANDARD')) RECOVERY_TYPE_CODE
4625: ,NULL RECOVERY_TYPE_ID
4626: ,NULL REF_DOC_CURR_CONV_RATE
4627: ,NULL REF_DOC_DIST_ID
4628: ,NULL REF_DOC_PER_UNIT_NREC_TAX_AMT

Line 4756: AND rates.recovery_type_code(+) = 'STANDARD'

4752: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
4753: AND rates.tax(+) = pohzd.tax
4754: AND rates.content_owner_id(+) = pohzd.content_owner_id
4755: AND rates.rate_type_code(+) = 'RECOVERY'
4756: AND rates.recovery_type_code(+) = 'STANDARD'
4757: AND rates.active_flag(+) = 'Y'
4758: AND rates.effective_from(+) <= sysdate
4759: --Bug 8724131
4760: --AND (rates.effective_to IS NULL OR rates.effective_to >= sysdate)

Line 5841: ,'STANDARD_TC' TAX_CALCULATION_FORMULA

5837: ,NULL TAX_APPLICABILITY_RESULT_ID
5838: ,'Y' TAX_APPORTIONMENT_FLAG
5839: ,1 TAX_APPORTIONMENT_LINE_NUMBER
5840: ,NULL TAX_BASE_MODIFIER_RATE
5841: ,'STANDARD_TC' TAX_CALCULATION_FORMULA
5842: ,NULL TAX_CODE
5843: ,taxes.tax_currency_code TAX_CURRENCY_CODE
5844: ,poh.rate_date TAX_CURRENCY_CONVERSION_DATE
5845: ,poh.rate TAX_CURRENCY_CONVERSION_RATE

Line 5887: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA

5883: ,NULL TAX_TYPE_CODE
5884: ,NULL TAXABLE_AMT
5885: ,NULL TAXABLE_AMT_FUNCL_CURR
5886: ,NULL TAXABLE_AMT_TAX_CURR
5887: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA
5888: ,NULL TAXING_JURIS_GEOGRAPHY_ID
5889: ,NULL THRESH_RESULT_ID
5890: ,NVL(poh.currency_code,
5891: poh.base_currency_code) TRX_CURRENCY_CODE

Line 6548: ,'STANDARD_TC' TAX_CALCULATION_FORMULA

6544: rates.tax_regime_code,
6545: rates.tax
6546: ORDER BY atg.tax_code_id) TAX_APPORTIONMENT_LINE_NUMBER
6547: ,NULL TAX_BASE_MODIFIER_RATE
6548: ,'STANDARD_TC' TAX_CALCULATION_FORMULA
6549: ,NULL TAX_CODE
6550: ,taxes.tax_currency_code TAX_CURRENCY_CODE
6551: ,poh.rate_date TAX_CURRENCY_CONVERSION_DATE
6552: ,poh.rate TAX_CURRENCY_CONVERSION_RATE

Line 6595: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA

6591: ,NULL TAX_TYPE_CODE
6592: ,NULL TAXABLE_AMT
6593: ,NULL TAXABLE_AMT_FUNCL_CURR
6594: ,NULL TAXABLE_AMT_TAX_CURR
6595: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA
6596: ,NULL TAXING_JURIS_GEOGRAPHY_ID
6597: ,NULL THRESH_RESULT_ID
6598: ,NVL(poh.currency_code,
6599: poh.base_currency_code) TRX_CURRENCY_CODE

Line 7014: 'STANDARD')) RECOVERY_TYPE_CODE

7010: ) RECOVERY_RATE_ID
7011: -- End : Code changes for Bug#13955562 --
7012: ,DECODE(tmp.rec_flag,'N', NULL,
7013: NVL(rates.recovery_type_code,
7014: 'STANDARD')) RECOVERY_TYPE_CODE
7015: ,NULL RECOVERY_TYPE_ID
7016: ,NULL REF_DOC_CURR_CONV_RATE
7017: ,NULL REF_DOC_DIST_ID
7018: ,NULL REF_DOC_PER_UNIT_NREC_TAX_AMT

Line 7151: AND rates.recovery_type_code(+) = 'STANDARD'

7147: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
7148: AND rates.tax(+) = pohzd.tax
7149: AND rates.content_owner_id(+) = pohzd.content_owner_id
7150: AND rates.rate_type_code(+) = 'RECOVERY'
7151: AND rates.recovery_type_code(+) = 'STANDARD'
7152: AND rates.active_flag(+) = 'Y'
7153: AND rates.effective_from(+) <= sysdate
7154: --Bug 8724131
7155: --AND (rates.effective_to IS NULL OR rates.effective_to >= sysdate)

Line 8162: ,'STANDARD_TC' TAX_CALCULATION_FORMULA

8158: ,NULL TAX_APPLICABILITY_RESULT_ID
8159: ,'Y' TAX_APPORTIONMENT_FLAG
8160: ,1 TAX_APPORTIONMENT_LINE_NUMBER
8161: ,NULL TAX_BASE_MODIFIER_RATE
8162: ,'STANDARD_TC' TAX_CALCULATION_FORMULA
8163: ,NULL TAX_CODE
8164: ,taxes.tax_currency_code TAX_CURRENCY_CODE
8165: ,poll.poh_rate_date TAX_CURRENCY_CONVERSION_DATE
8166: ,poll.poh_rate TAX_CURRENCY_CONVERSION_RATE

Line 8208: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA

8204: ,NULL TAX_TYPE_CODE
8205: ,NULL TAXABLE_AMT
8206: ,NULL TAXABLE_AMT_FUNCL_CURR
8207: ,NULL TAXABLE_AMT_TAX_CURR
8208: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA
8209: ,NULL TAXING_JURIS_GEOGRAPHY_ID
8210: ,NULL THRESH_RESULT_ID
8211: ,NVL(poll.poh_currency_code,
8212: poll.aps_base_currency_code) TRX_CURRENCY_CODE

Line 8878: ,'STANDARD_TC' TAX_CALCULATION_FORMULA

8874: rates.tax_regime_code,
8875: rates.tax
8876: ORDER BY atg.tax_code_id) TAX_APPORTIONMENT_LINE_NUMBER
8877: ,NULL TAX_BASE_MODIFIER_RATE
8878: ,'STANDARD_TC' TAX_CALCULATION_FORMULA
8879: ,NULL TAX_CODE
8880: ,taxes.tax_currency_code TAX_CURRENCY_CODE
8881: ,poll.poh_rate_date TAX_CURRENCY_CONVERSION_DATE
8882: ,poll.poh_rate TAX_CURRENCY_CONVERSION_RATE

Line 8925: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA

8921: ,NULL TAX_TYPE_CODE
8922: ,NULL TAXABLE_AMT
8923: ,NULL TAXABLE_AMT_FUNCL_CURR
8924: ,NULL TAXABLE_AMT_TAX_CURR
8925: ,'STANDARD_TB' TAXABLE_BASIS_FORMULA
8926: ,NULL TAXING_JURIS_GEOGRAPHY_ID
8927: ,NULL THRESH_RESULT_ID
8928: ,NVL(poll.poh_currency_code,
8929: poll.aps_base_currency_code) TRX_CURRENCY_CODE

Line 9353: 'STANDARD')) RECOVERY_TYPE_CODE

9349: ) RECOVERY_RATE_ID
9350: -- End : Code changes for Bug#13955562 --
9351: ,DECODE(tmp.rec_flag,'N', NULL,
9352: NVL(rates.recovery_type_code,
9353: 'STANDARD')) RECOVERY_TYPE_CODE
9354: ,NULL RECOVERY_TYPE_ID
9355: ,NULL REF_DOC_CURR_CONV_RATE
9356: ,NULL REF_DOC_DIST_ID
9357: ,NULL REF_DOC_PER_UNIT_NREC_TAX_AMT

Line 9491: AND rates.recovery_type_code(+) = 'STANDARD'

9487: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
9488: AND rates.tax(+) = pohzd.tax
9489: AND rates.content_owner_id(+) = pohzd.content_owner_id
9490: AND rates.rate_type_code(+) = 'RECOVERY'
9491: AND rates.recovery_type_code(+) = 'STANDARD'
9492: AND rates.active_flag(+) = 'Y'
9493: AND rates.effective_from(+) <= sysdate
9494: --Bug 8724131
9495: --AND (rates.effective_to IS NULL OR rates.effective_to >= sysdate)