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 MO_GLOBAL

Line 154: and khr.authoring_org_id = MO_GLOBAL.get_current_org_id

150: and khr.id = rul_hld.dnz_chr_id
151: and rgp.id = rul_hld.rgp_id
152: and rul_hld.rule_information_category = 'LAHUDT'
153: and TRUNC(NVL(FND_DATE.canonical_to_date(rul_hld.rule_information1), sysdate - 1)) < trunc(sysdate)
154: and khr.authoring_org_id = MO_GLOBAL.get_current_org_id
155: and stb.STREAM_TYPE_PURPOSE <> 'LATE_FEE' -- for bug 7295166 -- Don't charge late charge on late charge.
156: group by lte.name
157: ,khr.currency_code
158: ,lpt1.contract_number

Line 190: AND HD.ORG_ID = MO_GLOBAL.get_current_org_id

186: AND LN.ID = ST.LLN_ID
187: AND HD.ID = LN.CNR_ID
188: AND SM.ID = ST.STY_ID
189: AND CN.ID = ST.KHR_ID
190: AND HD.ORG_ID = MO_GLOBAL.get_current_org_id
191: AND ps.class = 'INV'
192: AND ps.STATUS = 'OP'
193: and nvl(st.late_charge_ass_yn, 'N') = 'N'
194: and st.khr_id = khr.id

Line 215: and khr.authoring_org_id = MO_GLOBAL.get_current_org_id

211: and khr.id = rul_hld.dnz_chr_id
212: and rgp.id = rul_hld.rgp_id
213: and rul_hld.rule_information_category = 'LAHUDT'
214: and TRUNC(NVL(FND_DATE.canonical_to_date(rul_hld.rule_information1), sysdate - 1)) < trunc(sysdate)
215: and khr.authoring_org_id = MO_GLOBAL.get_current_org_id
216: and SM.STREAM_TYPE_PURPOSE <> 'LATE_FEE' -- for bug 7295166 -- Don't charge late charge on late charge.
217: group by lte.name
218: ,khr.currency_code
219: ,CN.contract_number

Line 302: and khr.authoring_org_id = MO_GLOBAL.get_current_org_id

298: and khr.id = rul_hld.dnz_chr_id
299: and rgp.id = rul_hld.rgp_id
300: and rul_hld.rule_information_category = 'LAHUDT'
301: and TRUNC(NVL(FND_DATE.canonical_to_date(rul_hld.rule_information1), sysdate - 1)) < trunc(sysdate)
302: and khr.authoring_org_id = MO_GLOBAL.get_current_org_id
303: and exists (select'x' from ra_customer_trx_lines_all trxl where trxl.customer_trx_id=orig_arv.invoice_id and
304: trxl.interface_line_attribute6=khr.contract_number)
305: and exists (select'x' from ra_customer_trx_lines_all trxl where trxl.customer_trx_id=last_arv.invoice_id and
306: trxl.interface_line_attribute6=khr.contract_number)

Line 408: and khr.authoring_org_id = MO_GLOBAL.get_current_org_id

404: and rgp.id = rul_hld.rgp_id
405: and rul_hld.rule_information_category = 'LAHUDT'
406: and TRUNC(NVL(FND_DATE.canonical_to_date(rul_hld.rule_information1), sysdate - 1)) < trunc(sysdate)
407: -- and khr.authoring_org_id = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
408: and khr.authoring_org_id = MO_GLOBAL.get_current_org_id
409: group by lte.name, khr.currency_code, orig.contract_id,orig.contract_number
410: ,orig.consolidated_invoice_id, orig.consolidated_invoice_number
411: , lte.late_chrg_grace_period
412: having (trunc(max(last.due_date)) + nvl(lte.late_chrg_grace_period, 0)) < trunc(sysdate);