APPS.OKL_AM_ASSET_RETURN_WF dependencies on OKL_ASSET_CNDTNS

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 1694: FROM OKL_ASSET_CNDTNS ACD,

1690: l_init_msg_list VARCHAR2(1) := 'T';
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'

Line 1815: OKL_ASSET_CNDTNS ACD,

1811: ACN.RECOMMENDED_REPAIR DETAILS,
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

Line 1840: OKL_ASSET_CNDTNS_ALL ACD,

1836: FND2.MEANING DAMAGE_TYPE
1837: FROM OKL_ASSET_RETURNS_B OAR,
1838: OKC_K_HEADERS_ALL_B OKC,
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