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_QA_DATA_INTEGRITY dependencies on FND_LOOKUPS

Line 210: FROM FND_LOOKUPS fnd,

206:
207: CURSOR l_ctc_csr (p_cpl_id NUMBER) IS
208: SELECT ctc.JTOT_OBJECT1_CODE, ctc.OBJECT1_ID1, ctc.OBJECT1_ID2,
209: fnd.MEANING
210: FROM FND_LOOKUPS fnd,
211: OKC_CONTACTS ctc
212: WHERE fnd.LOOKUP_CODE = ctc.cro_code
213: AND fnd.LOOKUP_TYPE = 'OKC_CONTACT_ROLE'
214: AND ctc.cpl_id = p_cpl_id;

Line 220: FROM FND_LOOKUPS fnd,

216:
217: CURSOR l_cpl1_csr IS
218: SELECT cpl.ID, cpl.JTOT_OBJECT1_CODE, cpl.OBJECT1_ID1, cpl.OBJECT1_ID2,
219: fnd.MEANING, cpl.rle_code, cpl.chr_id, cpl.cle_id
220: FROM FND_LOOKUPS fnd,
221: OKC_K_PARTY_ROLES_B cpl
222: WHERE fnd.LOOKUP_CODE = cpl.rle_code
223: AND fnd.LOOKUP_TYPE = 'OKC_ROLE'
224: AND cpl.dnz_chr_id = p_chr_id;

Line 593: FROM FND_LOOKUPS fnd

589:
590: /* -- /striping/
591: CURSOR l_rul_csr IS
592: SELECT fnd.MEANING
593: FROM FND_LOOKUPS fnd
594: WHERE fnd.LOOKUP_CODE = p_rul_rec.RULE_INFORMATION_CATEGORY
595: AND fnd.LOOKUP_TYPE = 'OKC_RULE_DEF';
596: */
597: -- /striping/

Line 603: -- l_rule_def FND_LOOKUPS.MEANING%TYPE; -- /striping/

599: SELECT MEANING
600: FROM okc_rule_defs_v
601: WHERE RULE_CODE = p_rul_rec.RULE_INFORMATION_CATEGORY;
602:
603: -- l_rule_def FND_LOOKUPS.MEANING%TYPE; -- /striping/
604: l_rule_def okc_rule_defs_v.MEANING%TYPE;
605:
606:
607: l_dummy VARCHAR2(1);

Line 1013: FROM FND_LOOKUPS fnd

1009:
1010: -- use only for getting info about OKC_RULE_GROUP_DEF, don't use OKC_RULE_DEF -- /striping/
1011: CURSOR l_rgpm_csr IS
1012: SELECT fnd.MEANING
1013: FROM FND_LOOKUPS fnd
1014: WHERE fnd.LOOKUP_CODE = 'CURRENCY'
1015: AND fnd.LOOKUP_TYPE = 'OKC_RULE_GROUP_DEF';
1016: -- WHERE fnd.LOOKUP_CODE = 'CVN'
1017: -- AND fnd.LOOKUP_TYPE = 'OKC_RULE_DEF';

Line 1018: l_rgpm_meaning FND_LOOKUPS.MEANING%TYPE;

1014: WHERE fnd.LOOKUP_CODE = 'CURRENCY'
1015: AND fnd.LOOKUP_TYPE = 'OKC_RULE_GROUP_DEF';
1016: -- WHERE fnd.LOOKUP_CODE = 'CVN'
1017: -- AND fnd.LOOKUP_TYPE = 'OKC_RULE_DEF';
1018: l_rgpm_meaning FND_LOOKUPS.MEANING%TYPE;
1019:
1020: --
1021: -- modified as part of bug 2155930 (jkodiyan - 26/12/2001)
1022: -- Cursor to check Conversion rule at the header level with

Line 1045: FROM FND_LOOKUPS fnd,

1041: SELECT rgp.id, rgp.rgd_code, fnd.meaning rule_group_name,
1042: rgp.chr_id, rgp.cle_id,
1043: rgr.rdf_code, rgr.min_cardinality, rgr.max_cardinality,
1044: fnd1.meaning rule_name
1045: FROM FND_LOOKUPS fnd,
1046: FND_LOOKUPS fnd1,
1047: OKC_RG_DEF_RULES rgr,
1048: OKC_RULE_GROUPS_B rgp
1049: WHERE rgp.dnz_chr_id = p_chr_id

Line 1046: FND_LOOKUPS fnd1,

1042: rgp.chr_id, rgp.cle_id,
1043: rgr.rdf_code, rgr.min_cardinality, rgr.max_cardinality,
1044: fnd1.meaning rule_name
1045: FROM FND_LOOKUPS fnd,
1046: FND_LOOKUPS fnd1,
1047: OKC_RG_DEF_RULES rgr,
1048: OKC_RULE_GROUPS_B rgp
1049: WHERE rgp.dnz_chr_id = p_chr_id
1050: AND fnd.lookup_code = rgp.rgd_code

Line 1063: FROM FND_LOOKUPS fnd,

1059: SELECT rgp.id, rgp.rgd_code, fnd.meaning rule_group_name,
1060: rgp.chr_id, rgp.cle_id,
1061: rgr.rdf_code, rgr.min_cardinality, rgr.max_cardinality,
1062: fnd1.meaning rule_name
1063: FROM FND_LOOKUPS fnd,
1064: okc_rule_defs_v fnd1,
1065: OKC_RG_DEF_RULES rgr,
1066: OKC_RULE_GROUPS_B rgp
1067: WHERE rgp.dnz_chr_id = p_chr_id

Line 1080: FND_LOOKUPS fnd

1076: /* CURSOR l_rgr_csr(p_rgd_code IN okc_rg_def_rules.rgd_code%TYPE) IS
1077: SELECT rgr.rdf_code, rgr.min_cardinality, rgr.max_cardinality,
1078: fnd.meaning
1079: FROM OKC_RG_DEF_RULES rgr,
1080: FND_LOOKUPS fnd
1081: WHERE rgr.rgd_code = p_rgd_code
1082: AND rgr.rdf_code = fnd.lookup_code
1083: AND fnd.lookup_type = 'OKC_RULE_DEF';
1084: l_rgr_rec l_rgr_csr%ROWTYPE; */

Line 1378: FROM FND_LOOKUPS fndrle,

1374: CURSOR l_rrd_csr IS
1375: SELECT rgp.id "RGP_ID", rrd.id "RRD_ID", rgp.rgd_code , sre.rle_code,
1376: fndrgd.meaning "RGD_MEANING", fndrle.meaning "RLE_MEANING",
1377: rgp.chr_id, rgp.cle_id
1378: FROM FND_LOOKUPS fndrle,
1379: FND_LOOKUPS fndrgd,
1380: OKC_SUBCLASS_ROLES sre,
1381: OKC_RG_ROLE_DEFS rrd,
1382: OKC_SUBCLASS_RG_DEFS srd,

Line 1379: FND_LOOKUPS fndrgd,

1375: SELECT rgp.id "RGP_ID", rrd.id "RRD_ID", rgp.rgd_code , sre.rle_code,
1376: fndrgd.meaning "RGD_MEANING", fndrle.meaning "RLE_MEANING",
1377: rgp.chr_id, rgp.cle_id
1378: FROM FND_LOOKUPS fndrle,
1379: FND_LOOKUPS fndrgd,
1380: OKC_SUBCLASS_ROLES sre,
1381: OKC_RG_ROLE_DEFS rrd,
1382: OKC_SUBCLASS_RG_DEFS srd,
1383: OKC_RULE_GROUPS_B rgp,

Line 1410: FND_LOOKUPS fl

1406:
1407: CURSOR l_kpr_csr(p_id OKC_K_PARTY_ROLES_B.ID%TYPE) IS
1408: SELECT kpr.rle_code, fl.meaning
1409: FROM OKC_K_PARTY_ROLES_B kpr,
1410: FND_LOOKUPS fl
1411: WHERE kpr.id = p_id
1412: AND fl.lookup_type = 'OKC_ROLE'
1413: AND fl.lookup_code = kpr.rle_code;
1414: