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.JG_ZZ_JOURNAL_AP_PKG dependencies on FND_NUMBER

Line 712: ,NVL(fnd_number.canonical_to_number(JZVTD.assessable_value),0) TAXABLE_SEL_INV

708: ,NVL(JZVTD.taxable_amt,0) TAXABLE_AMOUNT
709: ,NVL(JZVTD.taxable_amt_funcl_curr,0) TAXABLE_BASE_AMOUNT
710: ,NVL(DECODE(JZVTD.offset_flag,'Y', -1*JZVTD.tax_amt,JZVTD.tax_amt),0) TAX_AMOUNT
711: ,NVL(DECODE(JZVTD.offset_flag,'Y', -1*JZVTD.tax_amt_funcl_curr,JZVTD.tax_amt_funcl_curr),0) TAX_BASE_AMOUNT
712: ,NVL(fnd_number.canonical_to_number(JZVTD.assessable_value),0) TAXABLE_SEL_INV
713: ,JZVTD.offset_tax_rate_code OFFSET_TAX_CODE_ID
714: ,DECODE(JZVTD.tax_recoverable_flag ,'Y',JZVTD.taxable_amt*(JZVTD.tax_recovery_rate/100)) TAXABLE_REC_AMT
715: ,DECODE(JZVTD.tax_recoverable_flag ,'N',JZVTD.taxable_amt*(JZVTD.tax_recovery_rate/100)) TAXABLE_NREC_AMT
716: ,DECODE(JZVTD.tax_recoverable_flag ,'Y',DECODE(JZVTD.offset_flag,'Y', -1*JZVTD.tax_amt,JZVTD.tax_amt)) TAX_REC_AMT

Line 921: NVL(DECODE(JZVTD.tax_recoverable_flag,'Y',NVL(fnd_number.canonical_to_number(zx.global_attribute1),0)*(JZVTD.tax_recovery_rate/100)),0),

917: ,JZVTD.gl_date ACCOUNTING_DATE
918: --,NVL(DECODE(tax_recoverable_flag,'Y',taxable_amt_funcl_curr*(JZVTD.tax_recovery_rate/100)),0) TAXABLE_REC_BASE_AMOUNT
919: ,decode(ZX.historical_flag,'Y',decode(ZX.global_attribute_category,'JE.IT.APXINWKB.DISTRIBUTIONS',
920: decode(JZVTD.trx_currency_code,cur.currency_code,
921: NVL(DECODE(JZVTD.tax_recoverable_flag,'Y',NVL(fnd_number.canonical_to_number(zx.global_attribute1),0)*(JZVTD.tax_recovery_rate/100)),0),
922: NVL(DECODE(JZVTD.tax_recoverable_flag,'Y',(NVL(fnd_number.canonical_to_number(zx.global_attribute1),0)*nvl(JZVTD.currency_conversion_rate,1)/
923: nvl(cur.minimum_accountable_unit,power(10,(-1*cur.precision))))*
924: nvl(cur.minimum_accountable_unit,power(10,(-1*cur.precision))))*(JZVTD.tax_recovery_rate/100),0)),
925: NVL(DECODE(JZVTD.tax_recoverable_flag,'Y',JZVTD.taxable_amt_funcl_curr*(JZVTD.tax_recovery_rate/100)),0)),

Line 922: NVL(DECODE(JZVTD.tax_recoverable_flag,'Y',(NVL(fnd_number.canonical_to_number(zx.global_attribute1),0)*nvl(JZVTD.currency_conversion_rate,1)/

918: --,NVL(DECODE(tax_recoverable_flag,'Y',taxable_amt_funcl_curr*(JZVTD.tax_recovery_rate/100)),0) TAXABLE_REC_BASE_AMOUNT
919: ,decode(ZX.historical_flag,'Y',decode(ZX.global_attribute_category,'JE.IT.APXINWKB.DISTRIBUTIONS',
920: decode(JZVTD.trx_currency_code,cur.currency_code,
921: NVL(DECODE(JZVTD.tax_recoverable_flag,'Y',NVL(fnd_number.canonical_to_number(zx.global_attribute1),0)*(JZVTD.tax_recovery_rate/100)),0),
922: NVL(DECODE(JZVTD.tax_recoverable_flag,'Y',(NVL(fnd_number.canonical_to_number(zx.global_attribute1),0)*nvl(JZVTD.currency_conversion_rate,1)/
923: nvl(cur.minimum_accountable_unit,power(10,(-1*cur.precision))))*
924: nvl(cur.minimum_accountable_unit,power(10,(-1*cur.precision))))*(JZVTD.tax_recovery_rate/100),0)),
925: NVL(DECODE(JZVTD.tax_recoverable_flag,'Y',JZVTD.taxable_amt_funcl_curr*(JZVTD.tax_recovery_rate/100)),0)),
926: NVL(DECODE(JZVTD.tax_recoverable_flag,'Y',JZVTD.taxable_amt_funcl_curr*(JZVTD.tax_recovery_rate/100)),0)) TAXABLE_REC_BASE_AMOUNT

Line 929: NVL(DECODE(JZVTD.tax_recoverable_flag,'Y',NVL(fnd_number.canonical_to_number(zx.global_attribute1),0)*(JZVTD.tax_recovery_rate/100)),0),

925: NVL(DECODE(JZVTD.tax_recoverable_flag,'Y',JZVTD.taxable_amt_funcl_curr*(JZVTD.tax_recovery_rate/100)),0)),
926: NVL(DECODE(JZVTD.tax_recoverable_flag,'Y',JZVTD.taxable_amt_funcl_curr*(JZVTD.tax_recovery_rate/100)),0)) TAXABLE_REC_BASE_AMOUNT
927: -- ,NVL(DECODE(tax_recoverable_flag,'Y',taxable_amt*(JZVTD.tax_recovery_rate/100)) ,0) TAXABLE_REC_AMOUNT
928: ,decode(ZX.historical_flag,'Y',decode(ZX.global_attribute_category,'JE.IT.APXINWKB.DISTRIBUTIONS',
929: NVL(DECODE(JZVTD.tax_recoverable_flag,'Y',NVL(fnd_number.canonical_to_number(zx.global_attribute1),0)*(JZVTD.tax_recovery_rate/100)),0),
930: NVL(DECODE(JZVTD.tax_recoverable_flag,'Y',JZVTD.taxable_amt*(JZVTD.tax_recovery_rate/100)),0)),
931: NVL(DECODE(JZVTD.tax_recoverable_flag,'Y',JZVTD.taxable_amt*(JZVTD.tax_recovery_rate/100)),0)) TAXABLE_REC_AMOUNT
932: ,NVL(DECODE(JZVTD.tax_recoverable_flag,'Y',JZVTD.tax_amt_funcl_curr),0) TAX_REC_BASE_AMOUNT
933: ,NVL(DECODE(JZVTD.tax_recoverable_flag,'Y',JZVTD.tax_amt),0) TAX_REC_AMOUNT

Line 937: NVL(DECODE(JZVTD.tax_recoverable_flag,'N',NVL(fnd_number.canonical_to_number(zx.global_attribute1),0)*(JZVTD.tax_recovery_rate/100)),0),

933: ,NVL(DECODE(JZVTD.tax_recoverable_flag,'Y',JZVTD.tax_amt),0) TAX_REC_AMOUNT
934: -- ,NVL(DECODE(tax_recoverable_flag,'N',taxable_amt_funcl_curr*(JZVTD.tax_recovery_rate/100)),0) TAXABLE_NREC_BASE_AMOUNT
935: ,decode(ZX.historical_flag,'Y',decode(ZX.global_attribute_category,'JE.IT.APXINWKB.DISTRIBUTIONS',
936: decode(JZVTD.trx_currency_code,cur.currency_code,
937: NVL(DECODE(JZVTD.tax_recoverable_flag,'N',NVL(fnd_number.canonical_to_number(zx.global_attribute1),0)*(JZVTD.tax_recovery_rate/100)),0),
938: NVL(DECODE(JZVTD.tax_recoverable_flag,'N',(NVL(fnd_number.canonical_to_number(zx.global_attribute1),0)*nvl(JZVTD.currency_conversion_rate,1)/
939: nvl(cur.minimum_accountable_unit,power(10,(-1*cur.precision))))*
940: nvl(cur.minimum_accountable_unit,power(10,(-1*cur.precision))))*(JZVTD.tax_recovery_rate/100),0)),
941: NVL(DECODE(JZVTD.tax_recoverable_flag,'N',JZVTD.taxable_amt_funcl_curr*(JZVTD.tax_recovery_rate/100)),0)),

Line 938: NVL(DECODE(JZVTD.tax_recoverable_flag,'N',(NVL(fnd_number.canonical_to_number(zx.global_attribute1),0)*nvl(JZVTD.currency_conversion_rate,1)/

934: -- ,NVL(DECODE(tax_recoverable_flag,'N',taxable_amt_funcl_curr*(JZVTD.tax_recovery_rate/100)),0) TAXABLE_NREC_BASE_AMOUNT
935: ,decode(ZX.historical_flag,'Y',decode(ZX.global_attribute_category,'JE.IT.APXINWKB.DISTRIBUTIONS',
936: decode(JZVTD.trx_currency_code,cur.currency_code,
937: NVL(DECODE(JZVTD.tax_recoverable_flag,'N',NVL(fnd_number.canonical_to_number(zx.global_attribute1),0)*(JZVTD.tax_recovery_rate/100)),0),
938: NVL(DECODE(JZVTD.tax_recoverable_flag,'N',(NVL(fnd_number.canonical_to_number(zx.global_attribute1),0)*nvl(JZVTD.currency_conversion_rate,1)/
939: nvl(cur.minimum_accountable_unit,power(10,(-1*cur.precision))))*
940: nvl(cur.minimum_accountable_unit,power(10,(-1*cur.precision))))*(JZVTD.tax_recovery_rate/100),0)),
941: NVL(DECODE(JZVTD.tax_recoverable_flag,'N',JZVTD.taxable_amt_funcl_curr*(JZVTD.tax_recovery_rate/100)),0)),
942: NVL(DECODE(JZVTD.tax_recoverable_flag,'N',JZVTD.taxable_amt_funcl_curr*(JZVTD.tax_recovery_rate/100)),0)) TAXABLE_NREC_BASE_AMOUNT

Line 945: NVL(DECODE(JZVTD.tax_recoverable_flag,'N',NVL(fnd_number.canonical_to_number(zx.global_attribute1),0)*(JZVTD.tax_recovery_rate/100)),0),

941: NVL(DECODE(JZVTD.tax_recoverable_flag,'N',JZVTD.taxable_amt_funcl_curr*(JZVTD.tax_recovery_rate/100)),0)),
942: NVL(DECODE(JZVTD.tax_recoverable_flag,'N',JZVTD.taxable_amt_funcl_curr*(JZVTD.tax_recovery_rate/100)),0)) TAXABLE_NREC_BASE_AMOUNT
943: --,NVL(DECODE(tax_recoverable_flag,'N',taxable_amt*(JZVTD.tax_recovery_rate/100)),0) TAXABLE_NREC_AMOUNT
944: ,decode(ZX.historical_flag,'Y',decode(ZX.global_attribute_category,'JE.IT.APXINWKB.DISTRIBUTIONS',
945: NVL(DECODE(JZVTD.tax_recoverable_flag,'N',NVL(fnd_number.canonical_to_number(zx.global_attribute1),0)*(JZVTD.tax_recovery_rate/100)),0),
946: NVL(DECODE(JZVTD.tax_recoverable_flag,'N',JZVTD.taxable_amt*(JZVTD.tax_recovery_rate/100)),0)),
947: NVL(DECODE(JZVTD.tax_recoverable_flag,'N',JZVTD.taxable_amt*(JZVTD.tax_recovery_rate/100)),0)) TAXABLE_NREC_AMOUNT
948: ,NVL(DECODE(JZVTD.tax_recoverable_flag,'N',JZVTD.tax_amt_funcl_curr),0) TAX_NREC_BASE_AMOUNT
949: ,NVL(DECODE(JZVTD.tax_recoverable_flag,'N',JZVTD.tax_amt) ,0) TAX_NREC_AMOUNT

Line 950: ,NVL(fnd_number.canonical_to_number(JZVTD.assessable_value),0) SEL_INV_AMOUNT

946: NVL(DECODE(JZVTD.tax_recoverable_flag,'N',JZVTD.taxable_amt*(JZVTD.tax_recovery_rate/100)),0)),
947: NVL(DECODE(JZVTD.tax_recoverable_flag,'N',JZVTD.taxable_amt*(JZVTD.tax_recovery_rate/100)),0)) TAXABLE_NREC_AMOUNT
948: ,NVL(DECODE(JZVTD.tax_recoverable_flag,'N',JZVTD.tax_amt_funcl_curr),0) TAX_NREC_BASE_AMOUNT
949: ,NVL(DECODE(JZVTD.tax_recoverable_flag,'N',JZVTD.tax_amt) ,0) TAX_NREC_AMOUNT
950: ,NVL(fnd_number.canonical_to_number(JZVTD.assessable_value),0) SEL_INV_AMOUNT
951: ,JZVTD.tax_recovery_rate RECOVERY_RATE
952: ,DECODE(JZVTD.offset_tax_rate_code, NULL,NVL(JZVTD.tax_amt,0) + NVL(JZVTD.taxable_amt,0),NVL(DECODE(JZVTD.TAX_RECOVERABLE_FLAG ,'Y',
953: JZVTD.TAXABLE_AMT),0) + NVL(DECODE(JZVTD.TAX_RECOVERABLE_FLAG ,'N',JZVTD.TAXABLE_AMT),0)) FOREIGN_AMT
954: ,JZVTD.tax_recoverable_flag TAX_RECOVERABLE_FLAG