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_CORE_REP_EXTRACT_PKG dependencies on FND_API

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

1546: where lines.application_id = 222
1547: and lines.trx_id = dtl.ADJUSTED_DOC_TRX_ID
1548: and lines.trx_line_id = dtl.APPLIED_TO_TRX_LINE_ID
1549: and lines.tax_rate_id = dtl.tax_rate_id
1550: and nvl(lines.hq_estb_reg_number,fnd_api.g_miss_char) =
1551: P_TRL_GLOBAL_VARIABLES_REC.FIRST_PARTY_TAX_REG_NUM
1552: )
1553: WHERE dtl.request_id = P_REQUEST_ID
1554: and dtl.EXTRACT_SOURCE_LEDGER = 'AR'

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

1562: where lines.application_id = 222
1563: and lines.trx_id = dtl.ADJUSTED_DOC_TRX_ID
1564: and lines.trx_line_id = dtl.APPLIED_TO_TRX_LINE_ID
1565: AND lines.tax_rate_id = dtl.tax_rate_id
1566: AND nvl(lines.hq_estb_reg_number,fnd_api.g_miss_char) =
1567: P_TRL_GLOBAL_VARIABLES_REC.FIRST_PARTY_TAX_REG_NUM
1568: )
1569: WHERE dtl.request_id = P_REQUEST_ID
1570: and dtl.EXTRACT_SOURCE_LEDGER = 'AR'