APPS.OKL_AM_ASSET_RETURN_WF dependencies on FND_LOOKUPS

Line 1760: FND_LOOKUPS FND1,

1756: FND2.MEANING DAMAGE_TYPE
1757: FROM OKL_AM_ASSET_RETURNS_UV AD,
1758: OKL_ASSET_CNDTNS ACD,
1759: OKL_ASSET_CNDTN_LNS_V ACN,
1760: FND_LOOKUPS FND1,
1761: FND_LOOKUPS FND2
1762: WHERE ACD.KLE_ID = AD.KLE_ID
1763: AND ACD.ID = C_ID
1764: AND ACD.ID = ACN.ACD_ID

Line 1761: FND_LOOKUPS FND2

1757: FROM OKL_AM_ASSET_RETURNS_UV AD,
1758: OKL_ASSET_CNDTNS ACD,
1759: OKL_ASSET_CNDTN_LNS_V ACN,
1760: FND_LOOKUPS FND1,
1761: FND_LOOKUPS FND2
1762: WHERE ACD.KLE_ID = AD.KLE_ID
1763: AND ACD.ID = C_ID
1764: AND ACD.ID = ACN.ACD_ID
1765: AND upper(nvl(ACN.APPROVED_YN, 'N')) <> 'Y'

Line 1786: FND_LOOKUPS FND1,

1782: OKC_K_LINES_V KLE,
1783: OKL_ASSET_CNDTNS_ALL ACD,
1784: OKL_AST_CNDTN_LNS_ALL_B ACNB,
1785: OKL_ASSET_CNDTN_LNS_TL ACNT,
1786: FND_LOOKUPS FND1,
1787: FND_LOOKUPS FND2
1788: WHERE OKC.ID = KLE.CHR_ID
1789: AND OAR.KLE_ID = KLE.ID
1790: AND ACD.KLE_ID = OAR.KLE_ID

Line 1787: FND_LOOKUPS FND2

1783: OKL_ASSET_CNDTNS_ALL ACD,
1784: OKL_AST_CNDTN_LNS_ALL_B ACNB,
1785: OKL_ASSET_CNDTN_LNS_TL ACNT,
1786: FND_LOOKUPS FND1,
1787: FND_LOOKUPS FND2
1788: WHERE OKC.ID = KLE.CHR_ID
1789: AND OAR.KLE_ID = KLE.ID
1790: AND ACD.KLE_ID = OAR.KLE_ID
1791: AND ACD.ID = c_id

Line 2103: FND_LOOKUPS FND,

2099: PFC.LAST_UPDATED_BY LAST_UPDATED_BY
2100: FROM OKL_PRTFL_CNTRCTS_B PFC,
2101: OKL_PRTFL_LINES_V PFCL,
2102: OKC_K_HEADERS_V AD,
2103: FND_LOOKUPS FND,
2104: JTF_RS_TEAMS_VL T
2105: WHERE PFC.KHR_ID = c_id
2106: AND PFC.ID = PFCL.PFC_ID
2107: AND AD.ID = PFC.KHR_ID

Line 2339: FND_LOOKUPS FND

2335: PFC.LAST_UPDATED_BY LAST_UPDATED_BY
2336: FROM OKL_PRTFL_CNTRCTS_B PFC,
2337: OKL_PRTFL_LINES_V PFCL,
2338: OKC_K_HEADERS_V AD,
2339: FND_LOOKUPS FND
2340: WHERE PFC.KHR_ID = c_id
2341: AND PFC.ID = PFCL.PFC_ID
2342: AND AD.ID = PFC.KHR_ID
2343: AND ASSET_TRACK_STRATEGY_CODE = FND.LOOKUP_CODE