1184:
1185: CURSOR c_asset_id1 (c_khr_id NUMBER,c_asset_id NUMBER,c_Asset_number VARCHAR2) IS
1186: SELECT CLE.ID ID1
1187: FROM OKC_K_LINES_B CLE,
1188: OKC_K_ITEMS CIM
1189: WHERE CLE.DNZ_CHR_ID=c_khr_id
1190: AND CIM.CLE_ID = CLE.ID
1191: AND CIM.JTOT_OBJECT1_CODE = 'OKX_ASSET'
1192: AND CIM.DNZ_CHR_ID = CLE.DNZ_CHR_ID