DBA Data[Home] [Help]

APPS.FUN_REPORT_PVT dependencies on FND_LOOKUPS

Line 448: fnd_lookups lkup,

444: FTH.attribute15,
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,

Line 1094: fnd_lookups lkup,

1090: FTH.attribute15,
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,

Line 1376: l_batch_status FND_LOOKUPS.meaning%TYPE;

1372: l_para_meaning_list VARCHAR2(2000);
1373:
1374: l_initiator_name HZ_PARTIES.party_name%TYPE;
1375: l_recipient_name HZ_PARTIES.party_name%TYPE;
1376: l_batch_status FND_LOOKUPS.meaning%TYPE;
1377: l_trx_status FND_LOOKUPS.meaning%TYPE;
1378: l_trx_type FUN_TRX_TYPES_VL.trx_type_name%TYPE;
1379: l_currency FND_CURRENCIES_VL.name%TYPE;
1380: l_encoding VARCHAR2(20);

Line 1377: l_trx_status FND_LOOKUPS.meaning%TYPE;

1373:
1374: l_initiator_name HZ_PARTIES.party_name%TYPE;
1375: l_recipient_name HZ_PARTIES.party_name%TYPE;
1376: l_batch_status FND_LOOKUPS.meaning%TYPE;
1377: l_trx_status FND_LOOKUPS.meaning%TYPE;
1378: l_trx_type FUN_TRX_TYPES_VL.trx_type_name%TYPE;
1379: l_currency FND_CURRENCIES_VL.name%TYPE;
1380: l_encoding VARCHAR2(20);
1381: l_offset INTEGER;

Line 1634: l_batch_status FND_LOOKUPS.meaning%TYPE;

1630: l_para_meaning_list VARCHAR2(2000);
1631:
1632: l_initiator_name HZ_PARTIES.party_name%TYPE;
1633: l_recipient_name HZ_PARTIES.party_name%TYPE;
1634: l_batch_status FND_LOOKUPS.meaning%TYPE;
1635: l_trx_status FND_LOOKUPS.meaning%TYPE;
1636: l_acc_type FND_LOOKUPS.meaning%TYPE;
1637: l_trx_type FUN_TRX_TYPES_VL.trx_type_name%TYPE;
1638: l_currency FND_CURRENCIES_VL.name%TYPE;

Line 1635: l_trx_status FND_LOOKUPS.meaning%TYPE;

1631:
1632: l_initiator_name HZ_PARTIES.party_name%TYPE;
1633: l_recipient_name HZ_PARTIES.party_name%TYPE;
1634: l_batch_status FND_LOOKUPS.meaning%TYPE;
1635: l_trx_status FND_LOOKUPS.meaning%TYPE;
1636: l_acc_type FND_LOOKUPS.meaning%TYPE;
1637: l_trx_type FUN_TRX_TYPES_VL.trx_type_name%TYPE;
1638: l_currency FND_CURRENCIES_VL.name%TYPE;
1639: l_transact_ledger GL_LEDGERS.name%TYPE;

Line 1636: l_acc_type FND_LOOKUPS.meaning%TYPE;

1632: l_initiator_name HZ_PARTIES.party_name%TYPE;
1633: l_recipient_name HZ_PARTIES.party_name%TYPE;
1634: l_batch_status FND_LOOKUPS.meaning%TYPE;
1635: l_trx_status FND_LOOKUPS.meaning%TYPE;
1636: l_acc_type FND_LOOKUPS.meaning%TYPE;
1637: l_trx_type FUN_TRX_TYPES_VL.trx_type_name%TYPE;
1638: l_currency FND_CURRENCIES_VL.name%TYPE;
1639: l_transact_ledger GL_LEDGERS.name%TYPE;
1640: l_trading_ledger GL_LEDGERS.name%TYPE;

Line 1693: FROM FND_LOOKUPS

1689: END IF;
1690: IF p_para_rec.account_type IS NOT NULL THEN
1691: SELECT meaning
1692: INTO l_acc_type
1693: FROM FND_LOOKUPS
1694: WHERE lookup_code = p_para_rec.account_type
1695: AND lookup_type ='ACCOUNT_TYPE';
1696: END IF;
1697: IF p_para_rec.transact_ledger IS NOT NULL THEN