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 497: l_severity fnd_lookups.MEANING%TYPE; --FND_LOG_EXCEPTIONS.SEVERITY%TYPE;

493: document_type in out NOCOPY varchar2)
494: IS
495: l_app_sn FND_APPLICATION_VL.APPLICATION_SHORT_NAME%TYPE;
496: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;
497: l_severity fnd_lookups.MEANING%TYPE; --FND_LOG_EXCEPTIONS.SEVERITY%TYPE;
498: l_system VARCHAR2(200);
499:
500: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
501: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;

Line 517: fnd_lookups fl

513: fnd_log_messages flm,
514: fnd_log_exceptions fle,
515: FND_LOG_UNIQUE_EXCEPTIONS flue,
516: fnd_application_vl fa,
517: fnd_lookups fl
518: WHERE
519: flm.log_sequence = document_id
520: and flm.log_sequence = fle.log_sequence
521: and fle.UNIQUE_EXCEPTION_ID = flue.UNIQUE_EXCEPTION_ID

Line 588: l_comp_type_d fnd_lookups.MEANING%TYPE;

584:
585: l_comp_sn FND_APP_COMPONENTS_VL.COMPONENT_NAME%TYPE;
586:
587: -- l_biz_flow_id FND_LOG_EXCEPTION_CONTEXT.LOG_SEQUENCE%TYPE;
588: l_comp_type_d fnd_lookups.MEANING%TYPE;
589:
590: l_app_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_APPL_ID%TYPE;
591: l_comp_id FND_LOG_TRANSACTION_CONTEXT.COMPONENT_ID%TYPE;
592: l_comp_type FND_LOG_TRANSACTION_CONTEXT.COMPONENT_TYPE%TYPE;

Line 610: fnd_lookups flu

606: l_app_sn, l_app_fn, l_comp_type_d, l_app_id, l_comp_type, l_comp_id
607: FROM fnd_log_transaction_context fltc,
608: fnd_log_messages flm,
609: fnd_application_vl fa,
610: fnd_lookups flu
611: WHERE
612: flm.log_sequence = document_id
613: and fltc.transaction_context_id = flm.transaction_context_id
614: and fltc.component_appl_id = fa.application_id (+)