DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on FND_LOOKUPS

Line 1052: FND_LOOKUPS fnd

1048: fnd.meaning,
1049: fnd.description,
1050: TRUNC(trn.creation_date) transaction_date
1051: FROM OKL_TRX_CONTRACTS trn,
1052: FND_LOOKUPS fnd
1053: WHERE trn.khr_id = p_khr_id
1054: --rkuttiya added for 12.1.1 Multi GAAP
1055: AND trn.representation_type = 'PRIMARY'
1056: --

Line 1081: FND_LOOKUPS fnd

1077: fnd.meaning,
1078: fnd.description,
1079: TRUNC(trn.creation_date) transaction_date
1080: FROM OKL_TRX_CONTRACTS trn,
1081: FND_LOOKUPS fnd
1082: WHERE trn.khr_id = p_khr_id
1083: --rkuttiya added for 12.1.1 Multi GAAP
1084: AND trn.representation_type = 'PRIMARY'
1085: --

Line 1110: FND_LOOKUPS fnd

1106: fnd.description,
1107: TRUNC(tas.creation_date) transaction_date
1108: FROM OKL_TRX_ASSETS tas,
1109: OKL_TXL_ASSETS_V tal,
1110: FND_LOOKUPS fnd
1111: WHERE tas.id = tal.tas_id
1112: AND tal.dnz_khr_id = p_khr_id
1113: AND trunc(tas.creation_date) >= trunc(p_date)
1114: AND fnd.lookup_type = 'OKL_TRANS_HEADER_TYPE'

Line 1130: FND_LOOKUPS fnd

1126: fnd.description,
1127: TRUNC(tas.creation_date) transaction_date
1128: FROM OKL_TRX_ASSETS tas,
1129: OKL_TXL_ASSETS_V tal,
1130: FND_LOOKUPS fnd
1131: WHERE tas.id = tal.tas_id
1132: AND tal.dnz_khr_id = p_khr_id
1133: AND trunc(tas.creation_date) >= trunc(p_date)
1134: AND fnd.lookup_type = 'OKL_TRANS_HEADER_TYPE'