DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_PO_PKG dependencies on DUAL

Line 2388: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp

2384: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
2385: ) pohzd,
2386: fnd_currencies fc,
2387: zx_rates_b rates,
2388: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
2389: WHERE pohzd.trx_currency_code = fc.currency_code(+)
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

Line 4750: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp

4746: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
4747: ) pohzd,
4748: fnd_currencies fc,
4749: zx_rates_b rates,
4750: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
4751: WHERE pohzd.trx_currency_code = fc.currency_code(+)
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

Line 7145: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp

7141: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
7142: ) pohzd,
7143: fnd_currencies fc,
7144: zx_rates_b rates,
7145: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
7146: WHERE pohzd.trx_currency_code = fc.currency_code(+)
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

Line 9485: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp

9481: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
9482: ) pohzd,
9483: fnd_currencies fc,
9484: zx_rates_b rates,
9485: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
9486: WHERE pohzd.trx_currency_code = fc.currency_code(+)
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