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_LEASEAPP_TEMPLATE_PVT dependencies on OKL_LEASEAPP_TEMPL_VERSIONS_V

Line 39: OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV

35: l_check_tmplt_comb VARCHAR2(1);
36: CURSOR c_chk_tmlt_cmbntn IS
37: SELECT 'x'
38: FROM Okl_Leaseapp_Templates LATV,
39: OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV
40: WHERE LATV.ID = LAVV.LEASEAPP_TEMPLATE_ID
41: AND LATV.CREDIT_REVIEW_PURPOSE = p_latv_rec.CREDIT_REVIEW_PURPOSE
42: AND LATV.CUST_CREDIT_CLASSIFICATION = p_latv_rec.CUST_CREDIT_CLASSIFICATION
43: -- Bug 5149659 udhenuko : Start - Uncommenting industry values check

Line 115: CURSOR c_get_lat_data( cp_lav_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE) IS

111:
112: l_chk_vers_sts VARCHAR2(1);
113:
114: -- cursor to get the LAT header information of the particular version
115: CURSOR c_get_lat_data( cp_lav_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE) IS
116: SELECT LATV.ID LAT_HDR_ID
117: , LATV.OBJECT_VERSION_NUMBER HDR_OBJ_VER_NO
118: , LAVV.OBJECT_VERSION_NUMBER VER_OBJ_VER_NO
119: FROM OKL_LEASEAPP_TEMPLATES LATV,

Line 120: OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV

116: SELECT LATV.ID LAT_HDR_ID
117: , LATV.OBJECT_VERSION_NUMBER HDR_OBJ_VER_NO
118: , LAVV.OBJECT_VERSION_NUMBER VER_OBJ_VER_NO
119: FROM OKL_LEASEAPP_TEMPLATES LATV,
120: OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV
121: WHERE LATV.ID = LAVV.LEASEAPP_TEMPLATE_ID
122: AND LAVV.ID = cp_lav_id;
123:
124: -- cursor to check if all the versions of the LAT are active

Line 127: FROM OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV

123:
124: -- cursor to check if all the versions of the LAT are active
125: CURSOR c_chk_ver_sts( cp_lat_id OKL_LEASEAPP_TEMPLATES.ID%TYPE) IS
126: SELECT 'X'
127: FROM OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV
128: WHERE LAVV.LEASEAPP_TEMPLATE_ID = cp_lat_id
129: AND LAVV.VERSION_STATUS <> G_STATUS_ACTIVE;
130:
131: l_module CONSTANT fnd_log_messages.module%TYPE :='okl.plsql.OKL_LEASEAPP_TEMPLATE_PVT.activate_lat';

Line 491: okl_leaseapp_templ_versions_v LAVV

487: --effective dates
488: CURSOR c_get_valid_dates( p_lat_id okl_leaseapp_templates.id%TYPE) IS
489: SELECT MIN(LAVV.valid_from) valid_from
490: FROM Okl_Leaseapp_Templates LATV,
491: okl_leaseapp_templ_versions_v LAVV
492: WHERE LATV.ID = LAVV.LEASEAPP_TEMPLATE_ID
493: AND LATV.ID = p_lat_id
494: GROUP BY LATV.ID;
495:

Line 519: okl_leaseapp_templ_versions_v lav

515: UNION
516: SELECT laa.VALID_FROM START_DATE
517: FROM OKL_LEASE_APPLICATIONS_B laa,
518: okl_leaseapp_templates lat,
519: okl_leaseapp_templ_versions_v lav
520: WHERE lat.id = lav.leaseapp_template_id
521: AND laa.LEASEAPP_TEMPLATE_ID = lav.ID
522: AND laa.APPLICATION_STATUS IN('CONV-CL','CONV-K','CR-APPROVED','CR-SUBMITTED',
523: 'PR-ACCEPTED','PR-APPROVED','PR-SUBMITTED')

Line 794: okl_leaseapp_templ_versions_v lav

790: --asawanka bug 4966317 fix starts
791: CURSOR get_latest_activever_dates(p_lat_id IN okl_leaseapp_templates.id%TYPE) IS
792: /* SELECT max(to_number(lav.version_number)), lav.valid_from,lav.valid_to
793: FROM okl_leaseapp_templates lat,
794: okl_leaseapp_templ_versions_v lav
795: WHERE lat.id = lav.leaseapp_template_id
796: AND lat.id = p_lat_id
797: group by lav.valid_from,lav.valid_to; */
798: --Fixed ssdeshpa Bug # 6487421 Start

Line 1171: CURSOR c_validate_checklist_tmplt(p_lavv_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE) IS

1167: l_debug_enabled VARCHAR2(10);
1168:
1169: --Declare Cursor Definations
1170: --Validate Checklist template
1171: CURSOR c_validate_checklist_tmplt(p_lavv_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE) IS
1172: SELECT CHECKLIST_NUMBER TEMPLATE_NUMBER
1173: FROM OKL_CHECKLISTS CHK,
1174: OKL_LEASEAPP_TEMPLATES LATV,
1175: OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV

Line 1175: OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV

1171: CURSOR c_validate_checklist_tmplt(p_lavv_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE) IS
1172: SELECT CHECKLIST_NUMBER TEMPLATE_NUMBER
1173: FROM OKL_CHECKLISTS CHK,
1174: OKL_LEASEAPP_TEMPLATES LATV,
1175: OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV
1176: WHERE LATV.ID = LAVV.LEASEAPP_TEMPLATE_ID
1177: AND LAVV.CHECKLIST_ID = CHK.ID
1178: AND ( (LAVV.VALID_FROM NOT BETWEEN NVL(CHK.START_DATE,LAVV.VALID_FROM)
1179: AND NVL(CHK.END_DATE,LAVV.VALID_FROM))

Line 1186: CURSOR c_validate_contract_tmplt(p_lavv_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE) IS

1182: OR CHK.ORG_ID <> LATV.ORG_ID)
1183: AND LAVV.ID = p_lavv_id;
1184:
1185: --Validate Contract Template
1186: CURSOR c_validate_contract_tmplt(p_lavv_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE) IS
1187: SELECT OKH.CONTRACT_NUMBER TEMPLATE_NUMBER
1188: FROM OKC_K_HEADERS_B OKH,
1189: OKL_LEASEAPP_TEMPLATES LATV,
1190: OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV,

Line 1190: OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV,

1186: CURSOR c_validate_contract_tmplt(p_lavv_id OKL_LEASEAPP_TEMPL_VERSIONS_V.ID%TYPE) IS
1187: SELECT OKH.CONTRACT_NUMBER TEMPLATE_NUMBER
1188: FROM OKC_K_HEADERS_B OKH,
1189: OKL_LEASEAPP_TEMPLATES LATV,
1190: OKL_LEASEAPP_TEMPL_VERSIONS_V LAVV,
1191: OKL_K_HEADERS KHR,
1192: OKC_STATUSES_V STS
1193: WHERE LATV.ID = LAVV.LEASEAPP_TEMPLATE_ID
1194: AND LAVV.CONTRACT_TEMPLATE_ID = OKH.ID

Line 1414: okl_leaseapp_templ_versions_v lav

1410: UNION
1411: SELECT laa.VALID_FROM START_DATE
1412: FROM OKL_LEASE_APPLICATIONS_B laa,
1413: okl_leaseapp_templates lat,
1414: okl_leaseapp_templ_versions_v lav
1415: WHERE lat.id = lav.leaseapp_template_id
1416: AND laa.LEASEAPP_TEMPLATE_ID = lav.ID
1417: AND laa.APPLICATION_STATUS IN('CONV-CL','CONV-K','CR-APPROVED','CR-SUBMITTED',
1418: 'PR-ACCEPTED','PR-APPROVED','PR-SUBMITTED')

Line 1426: okl_leaseapp_templ_versions_v lav

1422: --asawanka bug 4966317 fix starts
1423: CURSOR get_latest_activever_dates(p_lat_id IN okl_leaseapp_templates.id%TYPE) IS
1424: /* SELECT max(to_number(lav.version_number)), lav.valid_from,lav.valid_to
1425: FROM okl_leaseapp_templates lat,
1426: okl_leaseapp_templ_versions_v lav
1427: WHERE lat.id = lav.leaseapp_template_id
1428: AND lat.id = p_lat_id
1429: group by lav.valid_from,lav.valid_to;*/
1430: --Fixed ssdeshpa Bug # 6487421 Start