APPS.FUN_REPORT_PVT dependencies on FND_LOOKUP_VALUES

Line 136: FND_LOOKUP_VALUES LKUP,

132: FTH.attribute_category
133: FROM FUN_TRX_BATCHES FTB,
134: FUN_TRX_HEADERS FTH,
135: XLE_ENTITY_PROFILES XLE,
136: FND_LOOKUP_VALUES LKUP,
137: HZ_PARTIES INIT_P,
138: FUN_TRX_TYPES_VL FTTVL,
139: FND_CURRENCIES_VL FCV,
140: GL_LEDGERS GL,

Line 148: FND_LOOKUP_VALUES LKUP1,

144: FUN_TRX_HEADERS FTH_ORIG,
145: FUN_TRX_HEADERS FTH_REV,
146: HZ_PARTIES RECI_P,
147: XLE_ENTITY_PROFILES XLE1,
148: FND_LOOKUP_VALUES LKUP1,
149: FND_GRANTS FG,
150: FND_OBJECT_INSTANCE_SETS FOIS,
151: HZ_RELATIONSHIPS HZR,
152: HZ_ORG_CONTACTS HZC,

Line 449: fnd_lookup_values lkup1,

445: FTH.attribute_category
446: FROM fun_dist_lines fdl,
447: gl_code_combinations glcc,
448: fnd_lookups lkup,
449: fnd_lookup_values lkup1,
450: fnd_lookup_values lkup2,
451: FUN_TRX_BATCHES FTB,
452: FUN_TRX_BATCHES FTB_REV,
453: FUN_TRX_BATCHES FTB_ORIG,

Line 450: fnd_lookup_values lkup2,

446: FROM fun_dist_lines fdl,
447: gl_code_combinations glcc,
448: fnd_lookups lkup,
449: fnd_lookup_values lkup1,
450: fnd_lookup_values lkup2,
451: FUN_TRX_BATCHES FTB,
452: FUN_TRX_BATCHES FTB_REV,
453: FUN_TRX_BATCHES FTB_ORIG,
454: HZ_PARTIES INIT_P,

Line 799: FND_LOOKUP_VALUES LKUP,

795: FTH.attribute_category
796: FROM FUN_TRX_BATCHES FTB,
797: FUN_TRX_HEADERS FTH,
798: XLE_ENTITY_PROFILES XLE,
799: FND_LOOKUP_VALUES LKUP,
800: HZ_PARTIES INIT_P,
801: FUN_TRX_TYPES_VL FTTVL,
802: FND_CURRENCIES_VL FCV,
803: GL_LEDGERS GL,

Line 811: FND_LOOKUP_VALUES LKUP1,

807: FUN_TRX_HEADERS FTH_ORIG,
808: FUN_TRX_HEADERS FTH_REV,
809: HZ_PARTIES RECI_P,
810: XLE_ENTITY_PROFILES XLE1,
811: FND_LOOKUP_VALUES LKUP1,
812: FND_GRANTS FG,
813: FND_OBJECT_INSTANCE_SETS FOIS
814: WHERE FTH.batch_id(+) = FTB.batch_id
815: AND XLE.legal_entity_id = FTB.from_le_id

Line 1095: fnd_lookup_values lkup1,

1091: FTH.attribute_category
1092: FROM fun_dist_lines fdl,
1093: gl_code_combinations glcc,
1094: fnd_lookups lkup,
1095: fnd_lookup_values lkup1,
1096: fnd_lookup_values lkup2,
1097: FUN_TRX_BATCHES FTB,
1098: FUN_TRX_BATCHES FTB_REV,
1099: FUN_TRX_BATCHES FTB_ORIG,

Line 1096: fnd_lookup_values lkup2,

1092: FROM fun_dist_lines fdl,
1093: gl_code_combinations glcc,
1094: fnd_lookups lkup,
1095: fnd_lookup_values lkup1,
1096: fnd_lookup_values lkup2,
1097: FUN_TRX_BATCHES FTB,
1098: FUN_TRX_BATCHES FTB_REV,
1099: FUN_TRX_BATCHES FTB_ORIG,
1100: HZ_PARTIES INIT_P,

Line 1412: FROM FND_LOOKUP_VALUES

1408: END IF;
1409: IF p_para_rec.batch_status IS NOT NULL THEN
1410: SELECT meaning
1411: INTO l_batch_status
1412: FROM FND_LOOKUP_VALUES
1413: WHERE lookup_type = 'FUN_BATCH_STATUS'
1414: AND view_application_id = 435
1415: AND security_group_id =fnd_global.lookup_security_group(lookup_type,435)
1416: AND language = USERENV('LANG')

Line 1423: FROM FND_LOOKUP_VALUES

1419:
1420: IF p_para_rec.transaction_status IS NOT NULL THEN
1421: SELECT meaning
1422: INTO l_trx_status
1423: FROM FND_LOOKUP_VALUES
1424: WHERE lookup_type = 'FUN_TRX_STATUS'
1425: AND view_application_id = 435
1426: AND security_group_id=fnd_global.lookup_security_group(lookup_type,435)
1427: AND language = USERENV('LANG')

Line 1661: FROM FND_LOOKUP_VALUES

1657: BEGIN
1658: IF p_para_rec.batch_status IS NOT NULL THEN
1659: SELECT meaning
1660: INTO l_batch_status
1661: FROM FND_LOOKUP_VALUES
1662: WHERE lookup_type = 'FUN_BATCH_STATUS'
1663: AND view_application_id = 435
1664: AND security_group_id=fnd_global.lookup_security_group(lookup_type,435)
1665: AND language = USERENV('LANG')

Line 1671: FROM FND_LOOKUP_VALUES

1667: END IF;
1668: IF p_para_rec.transaction_status IS NOT NULL THEN
1669: SELECT meaning
1670: INTO l_trx_status
1671: FROM FND_LOOKUP_VALUES
1672: WHERE lookup_type = 'FUN_TRX_STATUS'
1673: AND view_application_id = 435
1674: AND security_group_id=fnd_global.lookup_security_group(lookup_type,435)
1675: AND language = USERENV('LANG')