APPS.OKL_AM_ASSET_RETURN_WF dependencies on OKL_ASSET_CNDTNS

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

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

Line 1758: OKL_ASSET_CNDTNS ACD,

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

Line 1783: OKL_ASSET_CNDTNS_ALL ACD,

1779: FND2.MEANING DAMAGE_TYPE
1780: FROM OKL_ASSET_RETURNS_B OAR,
1781: OKC_K_HEADERS_ALL_B OKC,
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