eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_COPY_ASSET_PVT dependencies on DUAL

Line 124: FROM dual;

120: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
121: -- cursor to get sequence number for asset number
122: Cursor c_instance_no_ib IS
123: select TO_CHAR(OKL_IBN_SEQ.NEXTVAL)
124: FROM dual;
125: BEGIN
126: OPEN c_instance_no_ib;
127: FETCH c_instance_no_ib INTO x_instance_number_ib;
128: IF (c_instance_no_ib%NOTFOUND) Then

Line 162: FROM dual;

158: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
159: -- cursor to get sequence number for asset number
160: Cursor c_asset_no(p_old_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE) IS
161: select p_old_asset_number||'_'||OKL_FAN_SEQ.NEXTVAL
162: FROM dual;
163: BEGIN
164: OPEN c_asset_no(p_old_asset_number);
165: FETCH c_asset_no INTO x_asset_number;
166: IF (c_asset_no%NOTFOUND) Then

Line 202: FROM dual;

198: lv_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE;
199: -- cursor to get sequence number for asset number
200: Cursor c_asset_no IS
201: select 'OKL'||OKL_FAN_SEQ.NEXTVAL
202: FROM dual;
203:
204: -- cursor to get check the existence of asset number
205: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE)
206: IS

Line 208: FROM DUAL

204: -- cursor to get check the existence of asset number
205: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE)
206: IS
207: SELECT 1
208: FROM DUAL
209: WHERE EXISTS (SELECT '1'
210: FROM OKL_TXL_ASSETS_B
211: WHERE asset_number = p_asset_number);
212:

Line 215: FROM DUAL

211: WHERE asset_number = p_asset_number);
212:
213: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
214: SELECT 1
215: FROM DUAL
216: WHERE EXISTS (SELECT '1'
217: FROM OKX_ASSET_LINES_V
218: WHERE asset_number = p_asset_number);
219:

Line 222: FROM DUAL

218: WHERE asset_number = p_asset_number);
219:
220: CURSOR c_okx_assets_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
221: SELECT 1
222: FROM DUAL
223: WHERE EXISTS (SELECT '1'
224: FROM OKX_ASSETS_V
225: WHERE asset_number = p_asset_number);
226:

Line 783: RESIDUAL_PERCENTAGE,

779: EVERGREEN_PERCENT,
780: AMOUNT_STAKE,
781: OCCUPANCY,
782: COVERAGE,
783: RESIDUAL_PERCENTAGE,
784: DATE_LAST_INSPECTION,
785: DATE_SOLD,
786: LRV_AMOUNT,
787: CAPITAL_REDUCTION,

Line 789: DATE_RESIDUAL_LAST_REVIEW,

785: DATE_SOLD,
786: LRV_AMOUNT,
787: CAPITAL_REDUCTION,
788: DATE_NEXT_INSPECTION_DUE,
789: DATE_RESIDUAL_LAST_REVIEW,
790: DATE_LAST_REAMORTISATION,
791: VENDOR_ADVANCE_PAID,
792: WEIGHTED_AVERAGE_LIFE,
793: TRADEIN_AMOUNT,

Line 814: RESIDUAL_VALUE,

810: REPURCHASED_AMOUNT,
811: DATE_COMMITMENT_EXPIRATION,
812: DATE_REPURCHASED,
813: DATE_APPRAISAL,
814: RESIDUAL_VALUE,
815: APPRAISAL_VALUE,
816: SECURED_DEAL_YN,
817: GAIN_LOSS,
818: FLOOR_AMOUNT,

Line 821: TRACKED_RESIDUAL,

817: GAIN_LOSS,
818: FLOOR_AMOUNT,
819: RE_LEASE_YN,
820: PREVIOUS_CONTRACT,
821: TRACKED_RESIDUAL,
822: DATE_TITLE_RECEIVED,
823: AMOUNT,
824: ATTRIBUTE_CATEGORY,
825: ATTRIBUTE1,

Line 853: RESIDUAL_GRNTY_AMOUNT,

849: DATE_ACCEPTED,
850: DATE_DELIVERY_EXPECTED,
851: OEC,
852: CAPITAL_AMOUNT,
853: RESIDUAL_GRNTY_AMOUNT,
854: RESIDUAL_CODE,
855: RVI_PREMIUM,
856: CREDIT_NATURE,
857: CAPITALIZED_INTEREST,

Line 854: RESIDUAL_CODE,

850: DATE_DELIVERY_EXPECTED,
851: OEC,
852: CAPITAL_AMOUNT,
853: RESIDUAL_GRNTY_AMOUNT,
854: RESIDUAL_CODE,
855: RVI_PREMIUM,
856: CREDIT_NATURE,
857: CAPITALIZED_INTEREST,
858: CAPITAL_REDUCTION_PERCENT,

Line 918: x_klev_rec.RESIDUAL_PERCENTAGE,

914: x_klev_rec.EVERGREEN_PERCENT,
915: x_klev_rec.AMOUNT_STAKE,
916: x_klev_rec.OCCUPANCY,
917: x_klev_rec.COVERAGE,
918: x_klev_rec.RESIDUAL_PERCENTAGE,
919: x_klev_rec.DATE_LAST_INSPECTION,
920: x_klev_rec.DATE_SOLD,
921: x_klev_rec.LRV_AMOUNT,
922: x_klev_rec.CAPITAL_REDUCTION,

Line 924: x_klev_rec.DATE_RESIDUAL_LAST_REVIEW,

920: x_klev_rec.DATE_SOLD,
921: x_klev_rec.LRV_AMOUNT,
922: x_klev_rec.CAPITAL_REDUCTION,
923: x_klev_rec.DATE_NEXT_INSPECTION_DUE,
924: x_klev_rec.DATE_RESIDUAL_LAST_REVIEW,
925: x_klev_rec.DATE_LAST_REAMORTISATION,
926: x_klev_rec.VENDOR_ADVANCE_PAID,
927: x_klev_rec.WEIGHTED_AVERAGE_LIFE,
928: x_klev_rec.TRADEIN_AMOUNT,

Line 949: x_klev_rec.RESIDUAL_VALUE,

945: x_klev_rec.REPURCHASED_AMOUNT,
946: x_klev_rec.DATE_COMMITMENT_EXPIRATION,
947: x_klev_rec.DATE_REPURCHASED,
948: x_klev_rec.DATE_APPRAISAL,
949: x_klev_rec.RESIDUAL_VALUE,
950: x_klev_rec.APPRAISAL_VALUE,
951: x_klev_rec.SECURED_DEAL_YN,
952: x_klev_rec.GAIN_LOSS,
953: x_klev_rec.FLOOR_AMOUNT,

Line 956: x_klev_rec.TRACKED_RESIDUAL,

952: x_klev_rec.GAIN_LOSS,
953: x_klev_rec.FLOOR_AMOUNT,
954: x_klev_rec.RE_LEASE_YN,
955: x_klev_rec.PREVIOUS_CONTRACT,
956: x_klev_rec.TRACKED_RESIDUAL,
957: x_klev_rec.DATE_TITLE_RECEIVED,
958: x_klev_rec.AMOUNT,
959: x_klev_rec.ATTRIBUTE_CATEGORY,
960: x_klev_rec.ATTRIBUTE1,

Line 988: x_klev_rec.RESIDUAL_GRNTY_AMOUNT,

984: x_klev_rec.DATE_ACCEPTED,
985: x_klev_rec.DATE_DELIVERY_EXPECTED,
986: x_klev_rec.OEC,
987: x_klev_rec.CAPITAL_AMOUNT,
988: x_klev_rec.RESIDUAL_GRNTY_AMOUNT,
989: x_klev_rec.RESIDUAL_CODE,
990: x_klev_rec.RVI_PREMIUM,
991: x_klev_rec.CREDIT_NATURE,
992: x_klev_rec.CAPITALIZED_INTEREST,

Line 989: x_klev_rec.RESIDUAL_CODE,

985: x_klev_rec.DATE_DELIVERY_EXPECTED,
986: x_klev_rec.OEC,
987: x_klev_rec.CAPITAL_AMOUNT,
988: x_klev_rec.RESIDUAL_GRNTY_AMOUNT,
989: x_klev_rec.RESIDUAL_CODE,
990: x_klev_rec.RVI_PREMIUM,
991: x_klev_rec.CREDIT_NATURE,
992: x_klev_rec.CAPITALIZED_INTEREST,
993: x_klev_rec.CAPITAL_REDUCTION_PERCENT,

Line 1339: NEW_RESIDUAL_VALUE,

1335: LAST_UPDATE_LOGIN,
1336: DEPRECIATE_YN,
1337: HOLD_PERIOD_DAYS,
1338: OLD_SALVAGE_VALUE,
1339: NEW_RESIDUAL_VALUE,
1340: OLD_RESIDUAL_VALUE,
1341: UNITS_RETIRED,
1342: COST_RETIRED,
1343: SALE_PROCEEDS,

Line 1340: OLD_RESIDUAL_VALUE,

1336: DEPRECIATE_YN,
1337: HOLD_PERIOD_DAYS,
1338: OLD_SALVAGE_VALUE,
1339: NEW_RESIDUAL_VALUE,
1340: OLD_RESIDUAL_VALUE,
1341: UNITS_RETIRED,
1342: COST_RETIRED,
1343: SALE_PROCEEDS,
1344: REMOVAL_COST,

Line 1426: x_txlv_rec.NEW_RESIDUAL_VALUE,

1422: x_txlv_rec.LAST_UPDATE_LOGIN,
1423: x_txlv_rec.DEPRECIATE_YN,
1424: x_txlv_rec.HOLD_PERIOD_DAYS,
1425: x_txlv_rec.OLD_SALVAGE_VALUE,
1426: x_txlv_rec.NEW_RESIDUAL_VALUE,
1427: x_txlv_rec.OLD_RESIDUAL_VALUE,
1428: x_txlv_rec.UNITS_RETIRED,
1429: x_txlv_rec.COST_RETIRED,
1430: x_txlv_rec.SALE_PROCEEDS,

Line 1427: x_txlv_rec.OLD_RESIDUAL_VALUE,

1423: x_txlv_rec.DEPRECIATE_YN,
1424: x_txlv_rec.HOLD_PERIOD_DAYS,
1425: x_txlv_rec.OLD_SALVAGE_VALUE,
1426: x_txlv_rec.NEW_RESIDUAL_VALUE,
1427: x_txlv_rec.OLD_RESIDUAL_VALUE,
1428: x_txlv_rec.UNITS_RETIRED,
1429: x_txlv_rec.COST_RETIRED,
1430: x_txlv_rec.SALE_PROCEEDS,
1431: x_txlv_rec.REMOVAL_COST,

Line 2302: FROM DUAL

2298: ln1_dummy NUMBER :=0;
2299: CURSOR c_validate_supp(p_cle_id OKL_K_LINES_V.ID%TYPE)
2300: IS
2301: SELECT 1
2302: FROM DUAL
2303: WHERE EXISTS (SELECT 1
2304: FROM OKL_SUPP_INVOICE_DTLS_V
2305: WHERE cle_id = p_cle_id);
2306:

Line 2763: FROM DUAL

2759: i NUMBER :=0;
2760: CURSOR c_trans_line_dtl_exist(p_tal_id OKL_K_LINES_V.ID%TYPE)
2761: IS
2762: SELECT 1
2763: FROM DUAL
2764: WHERE EXISTS (SELECT '1'
2765: FROM OKL_TXD_ASSETS_V
2766: WHERE tal_id = p_tal_id);
2767:

Line 4134: FROM DUAL

4130:
4131: CURSOR c_check_txl_rec(p_fa_kle_id OKL_K_LINES_V.ID%TYPE)
4132: IS
4133: SELECT 1
4134: FROM DUAL
4135: WHERE EXISTS (SELECT '1'
4136: FROM OKL_TXL_ASSETS_V
4137: WHERE kle_Id = p_fa_kle_id);
4138:

Line 4142: FROM DUAL

4138:
4139: CURSOR c_check_iti_rec(p_ib_kle_id OKL_K_LINES_V.ID%TYPE)
4140: IS
4141: SELECT 1
4142: FROM DUAL
4143: WHERE EXISTS (SELECT '1'
4144: FROM OKL_TXL_ITM_INSTS_V
4145: WHERE kle_id = p_ib_kle_id);
4146: