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.

[Home] [Help]

APPS.ZX_JE_EXTRACT_PKG dependencies on FND_API

Line 366: and nvl(lines.hq_estb_reg_number,fnd_api.g_miss_char) =

362: where lines.application_id = 222
363: and lines.trx_id = dtl.ADJUSTED_DOC_TRX_ID
364: and lines.trx_line_id = dtl.APPLIED_TO_TRX_LINE_ID
365: and lines.tax_rate_id = dtl.tax_rate_id
366: and nvl(lines.hq_estb_reg_number,fnd_api.g_miss_char) =
367: P_TRL_GLOBAL_VARIABLES_REC.FIRST_PARTY_TAX_REG_NUM
368: )
369: WHERE dtl.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
370: and dtl.EXTRACT_SOURCE_LEDGER = 'AR'

Line 382: AND nvl(lines.hq_estb_reg_number,fnd_api.g_miss_char) =

378: where lines.application_id = 222
379: and lines.trx_id = dtl.ADJUSTED_DOC_TRX_ID
380: and lines.trx_line_id = dtl.APPLIED_TO_TRX_LINE_ID
381: AND lines.tax_rate_id = dtl.tax_rate_id
382: AND nvl(lines.hq_estb_reg_number,fnd_api.g_miss_char) =
383: P_TRL_GLOBAL_VARIABLES_REC.FIRST_PARTY_TAX_REG_NUM
384: )
385: WHERE dtl.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
386: and dtl.EXTRACT_SOURCE_LEDGER = 'AR'