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 151: and khr.authoring_org_id = MO_GLOBAL.get_current_org_id

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
155: ,lpt1.contract_id

Line 186: AND HD.ORG_ID = MO_GLOBAL.get_current_org_id

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

Line 211: and khr.authoring_org_id = MO_GLOBAL.get_current_org_id

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
215: ,ST.KHR_id

Line 297: and khr.authoring_org_id = MO_GLOBAL.get_current_org_id

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
301: trxl.interface_line_attribute6=khr.contract_number)

Line 403: and khr.authoring_org_id = MO_GLOBAL.get_current_org_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
406: , lte.late_chrg_grace_period
407: having (trunc(max(last.due_date)) + nvl(lte.late_chrg_grace_period, 0)) < trunc(sysdate);