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_INT_PVT dependencies on FND_DATE

Line 102: , max(greatest(TRUNC((FND_DATE.canonical_to_date(NVL(rul_hld.rule_information1,AR_PAY.DUE_DATE)))),TRUNC(AR_PAY.DUE_DATE))) DUE_DATE

98: , ARL.RECEIVABLES_INVOICE_ID RECEIVABLES_INVOICE_ID
99: , KHR.contract_number
100: , ARL.CONTRACT_ID CONTRACT_ID
101: , sum(NVL(ARL.AMOUNT_DUE_ORIGINAL,0)) AMOUNT_APPLIED
102: , max(greatest(TRUNC((FND_DATE.canonical_to_date(NVL(rul_hld.rule_information1,AR_PAY.DUE_DATE)))),TRUNC(AR_PAY.DUE_DATE))) DUE_DATE
103: , max(TRUNC(AR_REC.APPLY_DATE)) APPLY_DATE
104: ,max('AR-INVOICE') invoice_flag
105: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
106: , AR_PAYMENT_SCHEDULES_ALL AR_PAY

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

139: and NVL(sty_exm.late_policy_exempt_yn, 'N') = 'Y')
140: and khr.id = rul_hld.dnz_chr_id
141: and rgp.id = rul_hld.rgp_id
142: and rul_hld.rule_information_category = 'LAHUDT'
143: and TRUNC(NVL(FND_DATE.canonical_to_date(NVL(rul_hld.rule_information1,sysdate)), sysdate - 1)) < trunc(sysdate)
144: and ((TRUNC((FND_DATE.canonical_to_date(rul_hld.rule_information1))) IS NOT NULL
145: AND TRUNC((FND_DATE.canonical_to_date(rul_hld.rule_information1))) < TRUNC(AR_REC.APPLY_DATE))
146: OR TRUNC(AR_REC.APPLY_DATE) IS NULL
147: OR rul_hld.rule_information1 IS NULL)

Line 144: and ((TRUNC((FND_DATE.canonical_to_date(rul_hld.rule_information1))) IS NOT NULL

140: and khr.id = rul_hld.dnz_chr_id
141: and rgp.id = rul_hld.rgp_id
142: and rul_hld.rule_information_category = 'LAHUDT'
143: and TRUNC(NVL(FND_DATE.canonical_to_date(NVL(rul_hld.rule_information1,sysdate)), sysdate - 1)) < trunc(sysdate)
144: and ((TRUNC((FND_DATE.canonical_to_date(rul_hld.rule_information1))) IS NOT NULL
145: AND TRUNC((FND_DATE.canonical_to_date(rul_hld.rule_information1))) < TRUNC(AR_REC.APPLY_DATE))
146: OR TRUNC(AR_REC.APPLY_DATE) IS NULL
147: OR rul_hld.rule_information1 IS NULL)
148: group by

Line 145: AND TRUNC((FND_DATE.canonical_to_date(rul_hld.rule_information1))) < TRUNC(AR_REC.APPLY_DATE))

141: and rgp.id = rul_hld.rgp_id
142: and rul_hld.rule_information_category = 'LAHUDT'
143: and TRUNC(NVL(FND_DATE.canonical_to_date(NVL(rul_hld.rule_information1,sysdate)), sysdate - 1)) < trunc(sysdate)
144: and ((TRUNC((FND_DATE.canonical_to_date(rul_hld.rule_information1))) IS NOT NULL
145: AND TRUNC((FND_DATE.canonical_to_date(rul_hld.rule_information1))) < TRUNC(AR_REC.APPLY_DATE))
146: OR TRUNC(AR_REC.APPLY_DATE) IS NULL
147: OR rul_hld.rule_information1 IS NULL)
148: group by
149: LTE.name

Line 162: , max(greatest(TRUNC((FND_DATE.canonical_to_date(NVL(rul_hld.rule_information1,AR_PAY.DUE_DATE)))),TRUNC(AR_PAY.DUE_DATE))) DUE_DATE

158: , CNSLD.RECEIVABLES_INVOICE_ID RECEIVABLES_INVOICE_ID
159: , KHR.contract_number
160: , CNSLD.KHR_ID CONTRACT_ID
161: , sum(NVL(AR_REC.AMOUNT_APPLIED,0)) AMOUNT_APPLIED
162: , max(greatest(TRUNC((FND_DATE.canonical_to_date(NVL(rul_hld.rule_information1,AR_PAY.DUE_DATE)))),TRUNC(AR_PAY.DUE_DATE))) DUE_DATE
163: , max(TRUNC(AR_REC.APPLY_DATE)) APPLY_DATE
164: , max('CONS-INVOICE') invoice_flag
165: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
166: , AR_PAYMENT_SCHEDULES_ALL AR_PAY

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

200: and NVL(sty_exm.late_policy_exempt_yn, 'N') = 'Y')
201: and khr.id = rul_hld.dnz_chr_id
202: and rgp.id = rul_hld.rgp_id
203: and rul_hld.rule_information_category = 'LAHUDT'
204: and TRUNC(NVL(FND_DATE.canonical_to_date(NVL(rul_hld.rule_information1,sysdate)), sysdate - 1)) < trunc(sysdate)
205: and ((TRUNC((FND_DATE.canonical_to_date(rul_hld.rule_information1))) IS NOT NULL
206: AND TRUNC((FND_DATE.canonical_to_date(rul_hld.rule_information1))) < TRUNC(AR_REC.APPLY_DATE))
207: OR TRUNC(AR_REC.APPLY_DATE) IS NULL
208: OR rul_hld.rule_information1 IS NULL)

Line 205: and ((TRUNC((FND_DATE.canonical_to_date(rul_hld.rule_information1))) IS NOT NULL

201: and khr.id = rul_hld.dnz_chr_id
202: and rgp.id = rul_hld.rgp_id
203: and rul_hld.rule_information_category = 'LAHUDT'
204: and TRUNC(NVL(FND_DATE.canonical_to_date(NVL(rul_hld.rule_information1,sysdate)), sysdate - 1)) < trunc(sysdate)
205: and ((TRUNC((FND_DATE.canonical_to_date(rul_hld.rule_information1))) IS NOT NULL
206: AND TRUNC((FND_DATE.canonical_to_date(rul_hld.rule_information1))) < TRUNC(AR_REC.APPLY_DATE))
207: OR TRUNC(AR_REC.APPLY_DATE) IS NULL
208: OR rul_hld.rule_information1 IS NULL)
209: group by LTE.name

Line 206: AND TRUNC((FND_DATE.canonical_to_date(rul_hld.rule_information1))) < TRUNC(AR_REC.APPLY_DATE))

202: and rgp.id = rul_hld.rgp_id
203: and rul_hld.rule_information_category = 'LAHUDT'
204: and TRUNC(NVL(FND_DATE.canonical_to_date(NVL(rul_hld.rule_information1,sysdate)), sysdate - 1)) < trunc(sysdate)
205: and ((TRUNC((FND_DATE.canonical_to_date(rul_hld.rule_information1))) IS NOT NULL
206: AND TRUNC((FND_DATE.canonical_to_date(rul_hld.rule_information1))) < TRUNC(AR_REC.APPLY_DATE))
207: OR TRUNC(AR_REC.APPLY_DATE) IS NULL
208: OR rul_hld.rule_information1 IS NULL)
209: group by LTE.name
210: , KHR.currency_code