APPS.OKL_LA_ASSET_PVT dependencies on OKL_OLD_LOAN_ASSETS_UV

Line 1160: from okl_old_loan_assets_uv oast

1156: -- oalc.location_id location_id,
1157: -- oast.fin_line_id parent_line_id,
1158: oast.parent_line_id,
1159: oast.dnz_chr_id
1160: from okl_old_loan_assets_uv oast
1161: where oast.dnz_chr_id = p_las_rec.dnz_chr_id
1162: and upper(oast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(oast.asset_number))
1163: and nvl(upper(oast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(oast.vendor_name),'x'))
1164: and oast.oec between nvl(p_las_rec.from_oec,oast.oec) and nvl(p_las_rec.to_oec,oast.oec)

Line 1212: from okl_old_loan_assets_uv oast

1208: -- oalc.location_id location_id,
1209: -- oast.fin_line_id parent_line_id,
1210: oast.parent_line_id,
1211: oast.dnz_chr_id
1212: from okl_old_loan_assets_uv oast
1213: where oast.dnz_chr_id = p_las_rec.dnz_chr_id
1214: and upper(oast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(oast.asset_number))
1215: and nvl(upper(oast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(oast.vendor_name),'x'))
1216: and oast.oec between nvl(p_las_rec.from_oec,oast.oec) and nvl(p_las_rec.to_oec,oast.oec)

Line 1517: from okl_old_loan_assets_uv oast

1513: oast.sts_code,
1514: oast.location_id,
1515: oast.parent_line_id,
1516: oast.dnz_chr_id
1517: from okl_old_loan_assets_uv oast
1518: where oast.dnz_chr_id = p_las_rec.dnz_chr_id
1519: and upper(oast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(oast.asset_number))
1520: and nvl(upper(oast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(oast.vendor_name),'x'))
1521: and oast.oec between nvl(p_las_rec.from_oec,oast.oec) and nvl(p_las_rec.to_oec,oast.oec)

Line 1586: from okl_old_loan_assets_uv oast

1582: oast.sts_code,
1583: oast.location_id,
1584: oast.parent_line_id,
1585: oast.dnz_chr_id
1586: from okl_old_loan_assets_uv oast
1587: where oast.dnz_chr_id = p_las_rec.dnz_chr_id
1588: and upper(oast.asset_number) like nvl(upper(p_las_rec.asset_number),upper(oast.asset_number))
1589: and nvl(upper(oast.vendor_name),'x') like nvl(upper(p_las_rec.vendor_name),nvl(upper(oast.vendor_name),'x'))
1590: and oast.oec between nvl(p_las_rec.from_oec,oast.oec) and nvl(p_las_rec.to_oec,oast.oec)