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_PRB_UPGRADE_PVT dependencies on XLE_LE_OU_LEDGER_V

Line 441: ,( SELECT DISTINCT legal_entity_name from XLE_LE_OU_LEDGER_V

437: IS
438: SELECT
439: (SELECT name from hr_operating_units where organization_id = p_org_id) org_id
440: ,DECODE(p_criteria_set, 'CONTRACT', 'Contract - Criteria', 'REAMORT', 'Reamort', 'Revision - Criteria' ) criteria_set
441: ,( SELECT DISTINCT legal_entity_name from XLE_LE_OU_LEDGER_V
442: WHERE legal_entity_id = p_le_id
443: AND rownum <= 1 ) le_id
444: ,( SELECT contract_number FROM OKC_K_HEADERS_B WHERE id = p_khr_id ) khr_id
445: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_BOOK_CLASS',p_book_classification) book_classification