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.OKL_LTE_CHRG_PVT dependencies on FND_DATE

Line 150: and TRUNC(NVL(FND_DATE.canonical_to_date(rul_hld.rule_information1), sysdate - 1)) < trunc(sysdate)

146: and NVL(sty_exm.late_policy_exempt_yn, 'N') = 'Y')
147: and khr.id = rul_hld.dnz_chr_id
148: and rgp.id = rul_hld.rgp_id
149: and rul_hld.rule_information_category = 'LAHUDT'
150: and TRUNC(NVL(FND_DATE.canonical_to_date(rul_hld.rule_information1), sysdate - 1)) < trunc(sysdate)
151: and khr.authoring_org_id = MO_GLOBAL.get_current_org_id
152: group by lte.name
153: ,khr.currency_code
154: ,lpt1.contract_number

Line 210: and TRUNC(NVL(FND_DATE.canonical_to_date(rul_hld.rule_information1), sysdate - 1)) < trunc(sysdate)

206: and NVL(sty_exm.late_policy_exempt_yn, 'N') = 'Y')
207: and khr.id = rul_hld.dnz_chr_id
208: and rgp.id = rul_hld.rgp_id
209: and rul_hld.rule_information_category = 'LAHUDT'
210: and TRUNC(NVL(FND_DATE.canonical_to_date(rul_hld.rule_information1), sysdate - 1)) < trunc(sysdate)
211: and khr.authoring_org_id = MO_GLOBAL.get_current_org_id
212: group by lte.name
213: ,khr.currency_code
214: ,CN.contract_number

Line 296: and TRUNC(NVL(FND_DATE.canonical_to_date(rul_hld.rule_information1), sysdate - 1)) < trunc(sysdate)

292: and NVL(sty_exm.late_policy_exempt_yn, 'N') = 'Y')
293: and khr.id = rul_hld.dnz_chr_id
294: and rgp.id = rul_hld.rgp_id
295: and rul_hld.rule_information_category = 'LAHUDT'
296: and TRUNC(NVL(FND_DATE.canonical_to_date(rul_hld.rule_information1), sysdate - 1)) < trunc(sysdate)
297: and khr.authoring_org_id = MO_GLOBAL.get_current_org_id
298: and exists (select'x' from ra_customer_trx_lines_all trxl where trxl.customer_trx_id=orig_arv.invoice_id and
299: trxl.interface_line_attribute6=khr.contract_number)
300: and exists (select'x' from ra_customer_trx_lines_all trxl where trxl.customer_trx_id=last_arv.invoice_id and

Line 401: and TRUNC(NVL(FND_DATE.canonical_to_date(rul_hld.rule_information1), sysdate - 1)) < trunc(sysdate)

397: and NVL(sty_exm.late_policy_exempt_yn, 'N') = 'Y')
398: and khr.id = rul_hld.dnz_chr_id
399: and rgp.id = rul_hld.rgp_id
400: and rul_hld.rule_information_category = 'LAHUDT'
401: and TRUNC(NVL(FND_DATE.canonical_to_date(rul_hld.rule_information1), sysdate - 1)) < trunc(sysdate)
402: -- and khr.authoring_org_id = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
403: and khr.authoring_org_id = MO_GLOBAL.get_current_org_id
404: group by lte.name, khr.currency_code, orig.contract_id,orig.contract_number
405: ,orig.consolidated_invoice_id, orig.consolidated_invoice_number