APPS.OKL_AM_ASSET_RETURN_WF dependencies on FND_LOOKUPS

Line 1817: FND_LOOKUPS FND1,

1813: FND2.MEANING DAMAGE_TYPE
1814: FROM OKL_AM_ASSET_RETURNS_UV AD,
1815: OKL_ASSET_CNDTNS ACD,
1816: OKL_ASSET_CNDTN_LNS_V ACN,
1817: FND_LOOKUPS FND1,
1818: FND_LOOKUPS FND2
1819: WHERE ACD.KLE_ID = AD.KLE_ID
1820: AND ACD.ID = C_ID
1821: AND ACD.ID = ACN.ACD_ID

Line 1818: FND_LOOKUPS FND2

1814: FROM OKL_AM_ASSET_RETURNS_UV AD,
1815: OKL_ASSET_CNDTNS ACD,
1816: OKL_ASSET_CNDTN_LNS_V ACN,
1817: FND_LOOKUPS FND1,
1818: FND_LOOKUPS FND2
1819: WHERE ACD.KLE_ID = AD.KLE_ID
1820: AND ACD.ID = C_ID
1821: AND ACD.ID = ACN.ACD_ID
1822: AND upper(nvl(ACN.APPROVED_YN, 'N')) <> 'Y'

Line 1843: FND_LOOKUPS FND1,

1839: OKC_K_LINES_V KLE,
1840: OKL_ASSET_CNDTNS_ALL ACD,
1841: OKL_AST_CNDTN_LNS_ALL_B ACNB,
1842: OKL_ASSET_CNDTN_LNS_TL ACNT,
1843: FND_LOOKUPS FND1,
1844: FND_LOOKUPS FND2
1845: WHERE OKC.ID = KLE.CHR_ID
1846: AND OAR.KLE_ID = KLE.ID
1847: AND ACD.KLE_ID = OAR.KLE_ID

Line 1844: FND_LOOKUPS FND2

1840: OKL_ASSET_CNDTNS_ALL ACD,
1841: OKL_AST_CNDTN_LNS_ALL_B ACNB,
1842: OKL_ASSET_CNDTN_LNS_TL ACNT,
1843: FND_LOOKUPS FND1,
1844: FND_LOOKUPS FND2
1845: WHERE OKC.ID = KLE.CHR_ID
1846: AND OAR.KLE_ID = KLE.ID
1847: AND ACD.KLE_ID = OAR.KLE_ID
1848: AND ACD.ID = c_id

Line 2160: FND_LOOKUPS FND,

2156: PFC.LAST_UPDATED_BY LAST_UPDATED_BY
2157: FROM OKL_PRTFL_CNTRCTS_B PFC,
2158: OKL_PRTFL_LINES_V PFCL,
2159: OKC_K_HEADERS_V AD,
2160: FND_LOOKUPS FND,
2161: JTF_RS_TEAMS_VL T
2162: WHERE PFC.KHR_ID = c_id
2163: AND PFC.ID = PFCL.PFC_ID
2164: AND AD.ID = PFC.KHR_ID

Line 2396: FND_LOOKUPS FND

2392: PFC.LAST_UPDATED_BY LAST_UPDATED_BY
2393: FROM OKL_PRTFL_CNTRCTS_B PFC,
2394: OKL_PRTFL_LINES_V PFCL,
2395: OKC_K_HEADERS_V AD,
2396: FND_LOOKUPS FND
2397: WHERE PFC.KHR_ID = c_id
2398: AND PFC.ID = PFCL.PFC_ID
2399: AND AD.ID = PFC.KHR_ID
2400: AND ASSET_TRACK_STRATEGY_CODE = FND.LOOKUP_CODE