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.LNS_REP_UTILS dependencies on LNS_LOOKUPS

Line 213: l_loan_status1_desc lns_lookups.meaning%TYPE;

209: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
210: l_legal_entity_name xle_entity_profiles.name%TYPE;
211: l_loan_product_name lns_loan_products_all.loan_product_name%TYPE;
212: l_loan_officer jtf_rs_resource_extns.source_name%TYPE;
213: l_loan_status1_desc lns_lookups.meaning%TYPE;
214: l_loan_status2_desc lns_lookups.meaning%TYPE;
215: l_include_charts VARCHAR2(30);
216: l_close_tag VARCHAR2(100);
217: l_query VARCHAR2(5000) :=

Line 214: l_loan_status2_desc lns_lookups.meaning%TYPE;

210: l_legal_entity_name xle_entity_profiles.name%TYPE;
211: l_loan_product_name lns_loan_products_all.loan_product_name%TYPE;
212: l_loan_officer jtf_rs_resource_extns.source_name%TYPE;
213: l_loan_status1_desc lns_lookups.meaning%TYPE;
214: l_loan_status2_desc lns_lookups.meaning%TYPE;
215: l_include_charts VARCHAR2(30);
216: l_close_tag VARCHAR2(100);
217: l_query VARCHAR2(5000) :=
218: 'select ' ||

Line 278: 'lns_lookups llk, ' ||

274: 'from ' ||
275: 'lns_loan_headers_all lh, ' ||
276: 'hz_parties hp, ' ||
277: 'lns_terms t, ' ||
278: 'lns_lookups llk, ' ||
279: 'LNS_PAY_SUM_V pay, ' ||
280: 'hz_cust_accounts_all account, ' ||
281: 'lns_lookups llkrt, ' ||
282: 'lns_lookups llktt, ' ||

Line 281: 'lns_lookups llkrt, ' ||

277: 'lns_terms t, ' ||
278: 'lns_lookups llk, ' ||
279: 'LNS_PAY_SUM_V pay, ' ||
280: 'hz_cust_accounts_all account, ' ||
281: 'lns_lookups llkrt, ' ||
282: 'lns_lookups llktt, ' ||
283: 'lns_lookups llks ' ||
284: 'where ' ||
285: 'lh.primary_borrower_id = hp.party_id and ' ||

Line 282: 'lns_lookups llktt, ' ||

278: 'lns_lookups llk, ' ||
279: 'LNS_PAY_SUM_V pay, ' ||
280: 'hz_cust_accounts_all account, ' ||
281: 'lns_lookups llkrt, ' ||
282: 'lns_lookups llktt, ' ||
283: 'lns_lookups llks ' ||
284: 'where ' ||
285: 'lh.primary_borrower_id = hp.party_id and ' ||
286: 'lh.loan_id = pay.loan_id and ' ||

Line 283: 'lns_lookups llks ' ||

279: 'LNS_PAY_SUM_V pay, ' ||
280: 'hz_cust_accounts_all account, ' ||
281: 'lns_lookups llkrt, ' ||
282: 'lns_lookups llktt, ' ||
283: 'lns_lookups llks ' ||
284: 'where ' ||
285: 'lh.primary_borrower_id = hp.party_id and ' ||
286: 'lh.loan_id = pay.loan_id and ' ||
287: 'lh.loan_id = t.loan_id and ' ||

Line 399: from lns_lookups

395: IF loan_status1 is NOT NULL
396: THEN
397: SELECT meaning
398: into l_loan_status1_desc
399: from lns_lookups
400: where lookup_type = 'LOAN_STATUS'
401: and lookup_code = loan_status1;
402: END IF;
403: IF loan_status2 is NOT NULL

Line 407: from lns_lookups

403: IF loan_status2 is NOT NULL
404: THEN
405: SELECT meaning
406: into l_loan_status2_desc
407: from lns_lookups
408: where lookup_type = 'LOAN_STATUS'
409: and lookup_code = loan_status2;
410: END IF;
411: IF legal_entity_id is NOT NULL

Line 578: l_loan_status1_desc lns_lookups.meaning%TYPE;

574: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
575: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
576: l_legal_entity_name xle_entity_profiles.name%TYPE;
577: l_loan_officer jtf_rs_resource_extns.source_name%TYPE;
578: l_loan_status1_desc lns_lookups.meaning%TYPE;
579: l_loan_status2_desc lns_lookups.meaning%TYPE;
580: l_close_tag VARCHAR2(100);
581: l_query VARCHAR2(11000) :=
582: 'select ' ||

Line 579: l_loan_status2_desc lns_lookups.meaning%TYPE;

575: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
576: l_legal_entity_name xle_entity_profiles.name%TYPE;
577: l_loan_officer jtf_rs_resource_extns.source_name%TYPE;
578: l_loan_status1_desc lns_lookups.meaning%TYPE;
579: l_loan_status2_desc lns_lookups.meaning%TYPE;
580: l_close_tag VARCHAR2(100);
581: l_query VARCHAR2(11000) :=
582: 'select ' ||
583: 'lh.LOAN_ID, ' ||

Line 670: ' LNS_LOOKUPS lok ' ||

666: ' from ' ||
667: ' lns_amortization_scheds am, ' ||
668: ' ar_payment_schedules_all psa, ' ||
669: ' RA_CUSTOMER_TRX_ALL trx, ' ||
670: ' LNS_LOOKUPS lok ' ||
671: ' where am.loan_id = lh.LOAN_ID and ' ||
672: ' (am.REVERSED_FLAG is null or am.REVERSED_FLAG = ''N'') and ' ||
673: ' trunc(am.DUE_DATE) between dateparameters.from_dt and dateparameters.to_dt and ' ||
674: ' (trx.customer_trx_id = am.PRINCIPAL_TRX_ID or ' ||

Line 768: ' lns_lookups fund_status, ' ||

764: ' fund_status.meaning status, ' ||
765: ' fund_act.meaning activity_name, ' ||
766: ' (select to_char(max(DISBURSEMENT_DATE),''MM/DD/YYYY'') from lns_disb_lines where DISB_HEADER_ID = head.DISB_HEADER_ID) DISBURSEMENT_DATE ' ||
767: ' from lns_disb_headers head, ' ||
768: ' lns_lookups fund_status, ' ||
769: ' lns_lookups fund_act ' ||
770: ' where head.loan_id = lh.loan_id and ' ||
771: ' fund_status.lookup_type(+) = ''FUNDING_STATUS'' and ' ||
772: ' fund_status.lookup_code(+) = head.STATUS and ' ||

Line 769: ' lns_lookups fund_act ' ||

765: ' fund_act.meaning activity_name, ' ||
766: ' (select to_char(max(DISBURSEMENT_DATE),''MM/DD/YYYY'') from lns_disb_lines where DISB_HEADER_ID = head.DISB_HEADER_ID) DISBURSEMENT_DATE ' ||
767: ' from lns_disb_headers head, ' ||
768: ' lns_lookups fund_status, ' ||
769: ' lns_lookups fund_act ' ||
770: ' where head.loan_id = lh.loan_id and ' ||
771: ' fund_status.lookup_type(+) = ''FUNDING_STATUS'' and ' ||
772: ' fund_status.lookup_code(+) = head.STATUS and ' ||
773: ' fund_act.lookup_type(+) = ''DISB_ACTIVITY'' and ' ||

Line 782: 'lns_lookups llk, ' ||

778: '(select lns_rep_utils.get_bill_due_date_from() from_dt, ' ||
779: ' lns_rep_utils.get_bill_due_date_to() to_dt ' ||
780: ' from dual) dateparameters, ' ||
781: 'hz_parties hp, ' ||
782: 'lns_lookups llk, ' ||
783: 'LNS_PAY_SUM_V pay, ' ||
784: 'hz_cust_accounts_all account, ' ||
785: 'hz_locations loc, ' ||
786: 'fnd_territories_vl terr, ' ||

Line 1177: FROM LNS_PARTICIPANTS lp, HZ_PARTIES party, AR_LOOKUPS lkup, LNS_LOOKUPS lnslkup,

1173: )
1174: )
1175: )
1176: )
1177: FROM LNS_PARTICIPANTS lp, HZ_PARTIES party, AR_LOOKUPS lkup, LNS_LOOKUPS lnslkup,
1178: FND_TERRITORIES_TL ter, HZ_CONTACT_POINTS cp, HZ_PARTIES contact_person,
1179: HZ_PARTIES contact_party, HZ_CONTACT_POINTS con_phone
1180: WHERE party.party_id =lp.HZ_PARTY_ID
1181: AND party.party_type = lkup.lookup_code

Line 1265: LNS_LOOKUPS lkps1,

1261: )
1262: )
1263: FROM LNS_ASSET_ASSIGNMENTS assetassign,
1264: LNS_ASSETS asset,
1265: LNS_LOOKUPS lkps1,
1266: LNS_LOOKUPS lkps2,
1267: LNS_LOOKUPS lkps3,
1268: LNS_LOOKUPS lkps4,
1269: LNS_LOOKUPS lkps5,

Line 1266: LNS_LOOKUPS lkps2,

1262: )
1263: FROM LNS_ASSET_ASSIGNMENTS assetassign,
1264: LNS_ASSETS asset,
1265: LNS_LOOKUPS lkps1,
1266: LNS_LOOKUPS lkps2,
1267: LNS_LOOKUPS lkps3,
1268: LNS_LOOKUPS lkps4,
1269: LNS_LOOKUPS lkps5,
1270: LNS_LOOKUPS lkps6,

Line 1267: LNS_LOOKUPS lkps3,

1263: FROM LNS_ASSET_ASSIGNMENTS assetassign,
1264: LNS_ASSETS asset,
1265: LNS_LOOKUPS lkps1,
1266: LNS_LOOKUPS lkps2,
1267: LNS_LOOKUPS lkps3,
1268: LNS_LOOKUPS lkps4,
1269: LNS_LOOKUPS lkps5,
1270: LNS_LOOKUPS lkps6,
1271: HZ_PARTIES party,

Line 1268: LNS_LOOKUPS lkps4,

1264: LNS_ASSETS asset,
1265: LNS_LOOKUPS lkps1,
1266: LNS_LOOKUPS lkps2,
1267: LNS_LOOKUPS lkps3,
1268: LNS_LOOKUPS lkps4,
1269: LNS_LOOKUPS lkps5,
1270: LNS_LOOKUPS lkps6,
1271: HZ_PARTIES party,
1272: LNS_PARTICIPANTS par

Line 1269: LNS_LOOKUPS lkps5,

1265: LNS_LOOKUPS lkps1,
1266: LNS_LOOKUPS lkps2,
1267: LNS_LOOKUPS lkps3,
1268: LNS_LOOKUPS lkps4,
1269: LNS_LOOKUPS lkps5,
1270: LNS_LOOKUPS lkps6,
1271: HZ_PARTIES party,
1272: LNS_PARTICIPANTS par
1273: WHERE assetassign.asset_id = asset.asset_id and

Line 1270: LNS_LOOKUPS lkps6,

1266: LNS_LOOKUPS lkps2,
1267: LNS_LOOKUPS lkps3,
1268: LNS_LOOKUPS lkps4,
1269: LNS_LOOKUPS lkps5,
1270: LNS_LOOKUPS lkps6,
1271: HZ_PARTIES party,
1272: LNS_PARTICIPANTS par
1273: WHERE assetassign.asset_id = asset.asset_id and
1274: asset.asset_owner_id = par.hz_party_id and

Line 1317: FROM LNS_FEE_ASSIGNMENTS lfa, LNS_FEES_ALL lf, LNS_LOOKUPS lkps1,

1313: )
1314: )
1315: )
1316: )
1317: FROM LNS_FEE_ASSIGNMENTS lfa, LNS_FEES_ALL lf, LNS_LOOKUPS lkps1,
1318: LNS_LOOKUPS llkbo,
1319: LNS_LOOKUPS llkrt,
1320: LNS_LOOKUPS llkfc,
1321: fnd_lookups fl

Line 1318: LNS_LOOKUPS llkbo,

1314: )
1315: )
1316: )
1317: FROM LNS_FEE_ASSIGNMENTS lfa, LNS_FEES_ALL lf, LNS_LOOKUPS lkps1,
1318: LNS_LOOKUPS llkbo,
1319: LNS_LOOKUPS llkrt,
1320: LNS_LOOKUPS llkfc,
1321: fnd_lookups fl
1322: WHERE lfa.FEE_ID = lf.FEE_ID AND

Line 1319: LNS_LOOKUPS llkrt,

1315: )
1316: )
1317: FROM LNS_FEE_ASSIGNMENTS lfa, LNS_FEES_ALL lf, LNS_LOOKUPS lkps1,
1318: LNS_LOOKUPS llkbo,
1319: LNS_LOOKUPS llkrt,
1320: LNS_LOOKUPS llkfc,
1321: fnd_lookups fl
1322: WHERE lfa.FEE_ID = lf.FEE_ID AND
1323: lfa.loan_id = lh.loan_id and

Line 1320: LNS_LOOKUPS llkfc,

1316: )
1317: FROM LNS_FEE_ASSIGNMENTS lfa, LNS_FEES_ALL lf, LNS_LOOKUPS lkps1,
1318: LNS_LOOKUPS llkbo,
1319: LNS_LOOKUPS llkrt,
1320: LNS_LOOKUPS llkfc,
1321: fnd_lookups fl
1322: WHERE lfa.FEE_ID = lf.FEE_ID AND
1323: lfa.loan_id = lh.loan_id and
1324: llkfc.lookup_type = 'FEE_CATEGORY' and

Line 1347: LNS_LOOKUPS lkps1 , fnd_lookups fl

1343: )
1344: )
1345: )
1346: FROM LNS_COND_ASSIGNMENTS_VL lca, LNS_CONDITIONS_VL lc,
1347: LNS_LOOKUPS lkps1 , fnd_lookups fl
1348: WHERE lca.CONDITION_ID = lc.CONDITION_ID
1349: AND lkps1.lookup_type = 'CONDITION_TYPE'
1350: AND lkps1.lookup_code = lc.CONDITION_TYPE
1351: AND fl.lookup_type = 'YES_NO'

Line 1452: LNS_LOOKUPS lkps1,

1448: )
1449: )
1450: FROM LNS_FEE_ASSIGNMENTS lfa,
1451: LNS_FEES_ALL lf,
1452: LNS_LOOKUPS lkps1,
1453: LNS_LOOKUPS llkbo,
1454: LNS_LOOKUPS llkrt,
1455: LNS_LOOKUPS llkfc,
1456: fnd_lookups fl

Line 1453: LNS_LOOKUPS llkbo,

1449: )
1450: FROM LNS_FEE_ASSIGNMENTS lfa,
1451: LNS_FEES_ALL lf,
1452: LNS_LOOKUPS lkps1,
1453: LNS_LOOKUPS llkbo,
1454: LNS_LOOKUPS llkrt,
1455: LNS_LOOKUPS llkfc,
1456: fnd_lookups fl
1457: WHERE lfa.FEE_ID = lf.FEE_ID AND

Line 1454: LNS_LOOKUPS llkrt,

1450: FROM LNS_FEE_ASSIGNMENTS lfa,
1451: LNS_FEES_ALL lf,
1452: LNS_LOOKUPS lkps1,
1453: LNS_LOOKUPS llkbo,
1454: LNS_LOOKUPS llkrt,
1455: LNS_LOOKUPS llkfc,
1456: fnd_lookups fl
1457: WHERE lfa.FEE_ID = lf.FEE_ID AND
1458: lfa.disb_header_id = ldih.disb_header_id and

Line 1455: LNS_LOOKUPS llkfc,

1451: LNS_FEES_ALL lf,
1452: LNS_LOOKUPS lkps1,
1453: LNS_LOOKUPS llkbo,
1454: LNS_LOOKUPS llkrt,
1455: LNS_LOOKUPS llkfc,
1456: fnd_lookups fl
1457: WHERE lfa.FEE_ID = lf.FEE_ID AND
1458: lfa.disb_header_id = ldih.disb_header_id and
1459: llkfc.lookup_type = 'FEE_CATEGORY' and

Line 1482: LNS_LOOKUPS lkps1 , fnd_lookups fl

1478: )
1479: )
1480: )
1481: FROM LNS_COND_ASSIGNMENTS_VL lca, LNS_CONDITIONS_VL lc,
1482: LNS_LOOKUPS lkps1 , fnd_lookups fl
1483: WHERE lca.CONDITION_ID = lc.CONDITION_ID
1484: AND lkps1.lookup_type = 'CONDITION_TYPE'
1485: AND lkps1.lookup_code = lc.CONDITION_TYPE
1486: AND fl.lookup_type = 'YES_NO'

Line 1496: ,lns_lookups llkac

1492: )
1493: )
1494: )
1495: FROM lns_disb_headers ldih
1496: ,lns_lookups llkac
1497: WHERE ldih.loan_id = lh.loan_id and
1498: llkac.lookup_code = ldih.activity_code
1499: ), -- end of DISBURSEMENTS
1500: -- AMORTIZATION

Line 1540: lns_lookups llkrt,

1536: hz_party_sites site,
1537: hz_cust_acct_sites_all acct_site,
1538: --LNS_PAY_SUM_V pay, --Bug5262505
1539: xle_firstparty_information_v xle,
1540: lns_lookups llkrt,
1541: lns_lookups llktt,
1542: lns_loan_types_vl llt,
1543: lns_lookups llklc,
1544: lns_lookups llkp,

Line 1541: lns_lookups llktt,

1537: hz_cust_acct_sites_all acct_site,
1538: --LNS_PAY_SUM_V pay, --Bug5262505
1539: xle_firstparty_information_v xle,
1540: lns_lookups llkrt,
1541: lns_lookups llktt,
1542: lns_loan_types_vl llt,
1543: lns_lookups llklc,
1544: lns_lookups llkp,
1545: lns_lookups llkst,

Line 1543: lns_lookups llklc,

1539: xle_firstparty_information_v xle,
1540: lns_lookups llkrt,
1541: lns_lookups llktt,
1542: lns_loan_types_vl llt,
1543: lns_lookups llklc,
1544: lns_lookups llkp,
1545: lns_lookups llkst,
1546: lns_lookups llkdc,
1547: lns_lookups llkfq,

Line 1544: lns_lookups llkp,

1540: lns_lookups llkrt,
1541: lns_lookups llktt,
1542: lns_loan_types_vl llt,
1543: lns_lookups llklc,
1544: lns_lookups llkp,
1545: lns_lookups llkst,
1546: lns_lookups llkdc,
1547: lns_lookups llkfq,
1548: lns_lookups llkfqf,

Line 1545: lns_lookups llkst,

1541: lns_lookups llktt,
1542: lns_loan_types_vl llt,
1543: lns_lookups llklc,
1544: lns_lookups llkp,
1545: lns_lookups llkst,
1546: lns_lookups llkdc,
1547: lns_lookups llkfq,
1548: lns_lookups llkfqf,
1549: lns_lookups llkic,

Line 1546: lns_lookups llkdc,

1542: lns_loan_types_vl llt,
1543: lns_lookups llklc,
1544: lns_lookups llkp,
1545: lns_lookups llkst,
1546: lns_lookups llkdc,
1547: lns_lookups llkfq,
1548: lns_lookups llkfqf,
1549: lns_lookups llkic,
1550: jtf_rs_resource_extns res,

Line 1547: lns_lookups llkfq,

1543: lns_lookups llklc,
1544: lns_lookups llkp,
1545: lns_lookups llkst,
1546: lns_lookups llkdc,
1547: lns_lookups llkfq,
1548: lns_lookups llkfqf,
1549: lns_lookups llkic,
1550: jtf_rs_resource_extns res,
1551: lns_disb_headers ldh,

Line 1548: lns_lookups llkfqf,

1544: lns_lookups llkp,
1545: lns_lookups llkst,
1546: lns_lookups llkdc,
1547: lns_lookups llkfq,
1548: lns_lookups llkfqf,
1549: lns_lookups llkic,
1550: jtf_rs_resource_extns res,
1551: lns_disb_headers ldh,
1552: lns_loan_products_all_vl product

Line 1549: lns_lookups llkic,

1545: lns_lookups llkst,
1546: lns_lookups llkdc,
1547: lns_lookups llkfq,
1548: lns_lookups llkfqf,
1549: lns_lookups llkic,
1550: jtf_rs_resource_extns res,
1551: lns_disb_headers ldh,
1552: lns_loan_products_all_vl product
1553: where