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.FND_OAM_KBF_SUBS dependencies on FND_LOOKUPS

Line 490: l_severity fnd_lookups.MEANING%TYPE; --FND_LOG_EXCEPTIONS.SEVERITY%TYPE;

486: document_type in out NOCOPY varchar2)
487: IS
488: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;
489: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;
490: l_severity fnd_lookups.MEANING%TYPE; --FND_LOG_EXCEPTIONS.SEVERITY%TYPE;
491: l_system VARCHAR2(200);
492:
493: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
494: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;

Line 510: fnd_lookups fl

506: fnd_log_messages flm,
507: fnd_log_exceptions fle,
508: FND_LOG_UNIQUE_EXCEPTIONS flue,
509: fnd_application_vl fa,
510: fnd_lookups fl
511: WHERE
512: flm.log_sequence = document_id
513: and flm.log_sequence = fle.log_sequence
514: and fle.UNIQUE_EXCEPTION_ID = flue.UNIQUE_EXCEPTION_ID

Line 581: l_comp_type_d fnd_lookups.MEANING%TYPE;

577:
578: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;
579:
580: -- l_biz_flow_id FND_LOG_EXCEPTION_CONTEXT.LOG_SEQUENCE%TYPE;
581: l_comp_type_d fnd_lookups.MEANING%TYPE;
582:
583: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
584: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;
585: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;

Line 600: fnd_lookups flu

596: l_app_sn, l_app_fn, l_comp_type_d, l_app_id, l_comp_type, l_comp_id
597: FROM fnd_log_transaction_context fltc,
598: fnd_log_messages flm,
599: fnd_application_vl fa,
600: fnd_lookups flu
601: WHERE
602: flm.log_sequence = document_id
603: and fltc.transaction_context_id = flm.transaction_context_id
604: and fltc.component_appl_id = fa.application_id (+)