APPS.OKL_AM_ASSET_RETURN_WF dependencies on OKL_ASSET_CNDTN_LNS_V

Line 1550: FROM OKL_ASSET_CNDTNS ACD, OKL_ASSET_CNDTN_LNS_V ACN

1546: -- cursor to check request is valid
1547: CURSOR okl_check_req_csr(c_id NUMBER)
1548: IS
1549: SELECT count(*)
1550: FROM OKL_ASSET_CNDTNS ACD, OKL_ASSET_CNDTN_LNS_V ACN
1551: WHERE ACD.ID = c_id
1552: AND ACD.ID = ACN.ACD_ID
1553: AND upper(nvl(ACN.APPROVED_YN, 'N')) <> 'Y'
1554: AND ACN.ACS_CODE = 'WAITING_FOR_APPROVAL';

Line 1638: OKL_ASSET_CNDTN_LNS_V ACN

1634:
1635: CURSOR c_rec_csr(C_ID NUMBER) IS
1636: SELECT ACN.ID id
1637: FROM OKL_ASSET_CNDTNS ACD,
1638: OKL_ASSET_CNDTN_LNS_V ACN
1639: WHERE ACD.ID = C_ID
1640: AND ACD.ID = ACN.ACD_ID
1641: AND nvl(UPPER(ACN.APPROVED_YN), 'N') <> 'Y'
1642: AND ACN.ACS_CODE = 'WAITING_FOR_APPROVAL';

Line 1759: OKL_ASSET_CNDTN_LNS_V ACN,

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