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

Line 2448: FND_LOOKUPS

2444:
2445: CURSOR l_sec_validate_csr IS
2446: SELECT lookup_code,meaning,description
2447: FROM
2448: FND_LOOKUPS
2449: WHERE lookup_type = 'OKC_ARTICLE_SECTION'
2450: AND lookup_code = p_section_name;
2451:
2452: CURSOR l_sec_seq_csr IS

Line 3776: FROM fnd_lookups

3772:
3773: CURSOR cur_val_lookup (p_lookup_type IN VARCHAR2, p_lookup_code IN VARCHAR2)
3774: IS
3775: SELECT 'Y'
3776: FROM fnd_lookups
3777: WHERE lookup_type = p_lookup_type
3778: AND lookup_code = p_lookup_code
3779: AND enabled_flag = 'Y'
3780: AND TRUNC (SYSDATE) BETWEEN NVL (start_date_active, SYSDATE - 1)

Line 3791: FROM fnd_lookups

3787: p_lookup_code IN VARCHAR2
3788: )
3789: IS
3790: SELECT 'Y', meaning
3791: FROM fnd_lookups
3792: WHERE lookup_type = p_lookup_type
3793: AND lookup_code = p_lookup_code
3794: AND enabled_flag = 'Y'
3795: AND TRUNC (SYSDATE) BETWEEN NVL (start_date_active, SYSDATE - 1)

Line 3825: FROM fnd_lookups

3821:
3822: CURSOR cur_val_lookup (p_lookup_type IN VARCHAR2, p_lookup_code IN VARCHAR2)
3823: IS
3824: SELECT 'Y'
3825: FROM fnd_lookups
3826: WHERE lookup_type = p_lookup_type
3827: AND lookup_code = p_lookup_code
3828: AND enabled_flag = 'Y'
3829: AND TRUNC (SYSDATE) BETWEEN NVL (start_date_active, SYSDATE - 1)

Line 3840: FROM fnd_lookups

3836: p_lookup_code IN VARCHAR2
3837: )
3838: IS
3839: SELECT 'Y', meaning
3840: FROM fnd_lookups
3841: WHERE lookup_type = p_lookup_type
3842: AND lookup_code = p_lookup_code
3843: AND enabled_flag = 'Y'
3844: AND TRUNC (SYSDATE) BETWEEN NVL (start_date_active, SYSDATE - 1)