APPS.OKL_AM_ASSET_RETURN_WF dependencies on OKL_ASSET_CNDTN_LNS_V

Line 1596: FROM OKL_ASSET_CNDTNS ACD, OKL_ASSET_CNDTN_LNS_V ACN

1592: -- cursor to check request is valid
1593: CURSOR okl_check_req_csr(c_id NUMBER)
1594: IS
1595: SELECT count(*)
1596: FROM OKL_ASSET_CNDTNS ACD, OKL_ASSET_CNDTN_LNS_V ACN
1597: WHERE ACD.ID = c_id
1598: AND ACD.ID = ACN.ACD_ID
1599: AND upper(nvl(ACN.APPROVED_YN, 'N')) <> 'Y'
1600: AND ACN.ACS_CODE = 'WAITING_FOR_APPROVAL';

Line 1695: OKL_ASSET_CNDTN_LNS_V ACN

1691:
1692: CURSOR c_rec_csr(C_ID NUMBER) IS
1693: SELECT ACN.ID id
1694: FROM OKL_ASSET_CNDTNS ACD,
1695: OKL_ASSET_CNDTN_LNS_V ACN
1696: WHERE ACD.ID = C_ID
1697: AND ACD.ID = ACN.ACD_ID
1698: AND nvl(UPPER(ACN.APPROVED_YN), 'N') <> 'Y'
1699: AND ACN.ACS_CODE = 'WAITING_FOR_APPROVAL';

Line 1816: OKL_ASSET_CNDTN_LNS_V ACN,

1812: FND1.MEANING CONDITION_TYPE,
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