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 239: l_loan_status1_desc lns_lookups.meaning%TYPE;

235: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
236: l_legal_entity_name xle_entity_profiles.name%TYPE;
237: l_loan_product_name lns_loan_products_all.loan_product_name%TYPE;
238: l_loan_officer jtf_rs_resource_extns.source_name%TYPE;
239: l_loan_status1_desc lns_lookups.meaning%TYPE;
240: l_loan_status2_desc lns_lookups.meaning%TYPE;
241: l_include_charts VARCHAR2(30);
242: l_close_tag VARCHAR2(100);
243: l_query VARCHAR2(5000) :=

Line 240: l_loan_status2_desc lns_lookups.meaning%TYPE;

236: l_legal_entity_name xle_entity_profiles.name%TYPE;
237: l_loan_product_name lns_loan_products_all.loan_product_name%TYPE;
238: l_loan_officer jtf_rs_resource_extns.source_name%TYPE;
239: l_loan_status1_desc lns_lookups.meaning%TYPE;
240: l_loan_status2_desc lns_lookups.meaning%TYPE;
241: l_include_charts VARCHAR2(30);
242: l_close_tag VARCHAR2(100);
243: l_query VARCHAR2(5000) :=
244: 'select ' ||

Line 304: 'lns_lookups llk, ' ||

300: 'from ' ||
301: 'lns_loan_headers_all_vl lh, ' ||
302: 'hz_parties hp, ' ||
303: 'lns_terms t, ' ||
304: 'lns_lookups llk, ' ||
305: 'LNS_PAY_SUM_V pay, ' ||
306: 'hz_cust_accounts_all account, ' ||
307: 'lns_lookups llkrt, ' ||
308: 'lns_lookups llktt, ' ||

Line 307: 'lns_lookups llkrt, ' ||

303: 'lns_terms t, ' ||
304: 'lns_lookups llk, ' ||
305: 'LNS_PAY_SUM_V pay, ' ||
306: 'hz_cust_accounts_all account, ' ||
307: 'lns_lookups llkrt, ' ||
308: 'lns_lookups llktt, ' ||
309: 'lns_lookups llks ' ||
310: 'where ' ||
311: 'lh.primary_borrower_id = hp.party_id and ' ||

Line 308: 'lns_lookups llktt, ' ||

304: 'lns_lookups llk, ' ||
305: 'LNS_PAY_SUM_V pay, ' ||
306: 'hz_cust_accounts_all account, ' ||
307: 'lns_lookups llkrt, ' ||
308: 'lns_lookups llktt, ' ||
309: 'lns_lookups llks ' ||
310: 'where ' ||
311: 'lh.primary_borrower_id = hp.party_id and ' ||
312: 'lh.loan_id = pay.loan_id and ' ||

Line 309: 'lns_lookups llks ' ||

305: 'LNS_PAY_SUM_V pay, ' ||
306: 'hz_cust_accounts_all account, ' ||
307: 'lns_lookups llkrt, ' ||
308: 'lns_lookups llktt, ' ||
309: 'lns_lookups llks ' ||
310: 'where ' ||
311: 'lh.primary_borrower_id = hp.party_id and ' ||
312: 'lh.loan_id = pay.loan_id and ' ||
313: 'lh.loan_id = t.loan_id and ' ||

Line 450: from lns_lookups

446: IF loan_status1 is NOT NULL
447: THEN
448: SELECT meaning
449: into l_loan_status1_desc
450: from lns_lookups
451: where lookup_type = 'LOAN_STATUS'
452: and lookup_code = loan_status1;
453: END IF;
454: IF loan_status2 is NOT NULL

Line 458: from lns_lookups

454: IF loan_status2 is NOT NULL
455: THEN
456: SELECT meaning
457: into l_loan_status2_desc
458: from lns_lookups
459: where lookup_type = 'LOAN_STATUS'
460: and lookup_code = loan_status2;
461: END IF;
462: IF legal_entity_id is NOT NULL

Line 641: l_loan_status1_desc lns_lookups.meaning%TYPE;

637: l_loan_type_id lns_loan_types.loan_type_id%TYPE;
638: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
639: l_legal_entity_name xle_entity_profiles.name%TYPE;
640: l_loan_officer jtf_rs_resource_extns.source_name%TYPE;
641: l_loan_status1_desc lns_lookups.meaning%TYPE;
642: l_loan_status2_desc lns_lookups.meaning%TYPE;
643: l_close_tag VARCHAR2(100);
644: l_query VARCHAR2(11000) :=
645: 'select ' ||

Line 642: l_loan_status2_desc lns_lookups.meaning%TYPE;

638: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
639: l_legal_entity_name xle_entity_profiles.name%TYPE;
640: l_loan_officer jtf_rs_resource_extns.source_name%TYPE;
641: l_loan_status1_desc lns_lookups.meaning%TYPE;
642: l_loan_status2_desc lns_lookups.meaning%TYPE;
643: l_close_tag VARCHAR2(100);
644: l_query VARCHAR2(11000) :=
645: 'select ' ||
646: 'lh.LOAN_ID, ' ||

Line 733: ' LNS_LOOKUPS lok ' ||

729: ' from ' ||
730: ' lns_amortization_scheds am, ' ||
731: ' ar_payment_schedules_all psa, ' ||
732: ' RA_CUSTOMER_TRX_ALL trx, ' ||
733: ' LNS_LOOKUPS lok ' ||
734: ' where am.loan_id = lh.LOAN_ID and ' ||
735: ' (am.REVERSED_FLAG is null or am.REVERSED_FLAG = ''N'') and ' ||
736: ' trunc(am.DUE_DATE) between dateparameters.from_dt and dateparameters.to_dt and ' ||
737: ' (trx.customer_trx_id = am.PRINCIPAL_TRX_ID or ' ||

Line 831: ' lns_lookups fund_status, ' ||

827: ' fund_status.meaning status, ' ||
828: ' fund_act.meaning activity_name, ' ||
829: ' (select to_char(max(DISBURSEMENT_DATE),''YYYY-MM-DD'') from lns_disb_lines where DISB_HEADER_ID = head.DISB_HEADER_ID) DISBURSEMENT_DATE ' ||
830: ' from lns_disb_headers head, ' ||
831: ' lns_lookups fund_status, ' ||
832: ' lns_lookups fund_act ' ||
833: ' where head.loan_id = lh.loan_id and ' ||
834: ' fund_status.lookup_type(+) = ''FUNDING_STATUS'' and ' ||
835: ' fund_status.lookup_code(+) = head.STATUS and ' ||

Line 832: ' lns_lookups fund_act ' ||

828: ' fund_act.meaning activity_name, ' ||
829: ' (select to_char(max(DISBURSEMENT_DATE),''YYYY-MM-DD'') from lns_disb_lines where DISB_HEADER_ID = head.DISB_HEADER_ID) DISBURSEMENT_DATE ' ||
830: ' from lns_disb_headers head, ' ||
831: ' lns_lookups fund_status, ' ||
832: ' lns_lookups fund_act ' ||
833: ' where head.loan_id = lh.loan_id and ' ||
834: ' fund_status.lookup_type(+) = ''FUNDING_STATUS'' and ' ||
835: ' fund_status.lookup_code(+) = head.STATUS and ' ||
836: ' fund_act.lookup_type(+) = ''DISB_ACTIVITY'' and ' ||

Line 845: 'lns_lookups llk, ' ||

841: '(select lns_rep_utils.get_bill_due_date_from() from_dt, ' ||
842: ' lns_rep_utils.get_bill_due_date_to() to_dt ' ||
843: ' from dual) dateparameters, ' ||
844: 'hz_parties hp, ' ||
845: 'lns_lookups llk, ' ||
846: 'LNS_PAY_SUM_V pay, ' ||
847: 'hz_cust_accounts_all account, ' ||
848: 'hz_locations loc, ' ||
849: 'fnd_territories_vl terr, ' ||

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

1267: )
1268: )
1269: )
1270: )
1271: FROM LNS_PARTICIPANTS lp, HZ_PARTIES party, AR_LOOKUPS lkup, LNS_LOOKUPS lnslkup,
1272: FND_TERRITORIES_TL ter, HZ_CONTACT_POINTS cp, HZ_PARTIES contact_person,
1273: HZ_PARTIES contact_party, HZ_CONTACT_POINTS con_phone
1274: WHERE party.party_id =lp.HZ_PARTY_ID
1275: AND party.party_type = lkup.lookup_code

Line 1359: LNS_LOOKUPS lkps1,

1355: )
1356: )
1357: FROM LNS_ASSET_ASSIGNMENTS assetassign,
1358: LNS_ASSETS asset,
1359: LNS_LOOKUPS lkps1,
1360: LNS_LOOKUPS lkps2,
1361: LNS_LOOKUPS lkps3,
1362: LNS_LOOKUPS lkps4,
1363: LNS_LOOKUPS lkps5,

Line 1360: LNS_LOOKUPS lkps2,

1356: )
1357: FROM LNS_ASSET_ASSIGNMENTS assetassign,
1358: LNS_ASSETS asset,
1359: LNS_LOOKUPS lkps1,
1360: LNS_LOOKUPS lkps2,
1361: LNS_LOOKUPS lkps3,
1362: LNS_LOOKUPS lkps4,
1363: LNS_LOOKUPS lkps5,
1364: LNS_LOOKUPS lkps6,

Line 1361: LNS_LOOKUPS lkps3,

1357: FROM LNS_ASSET_ASSIGNMENTS assetassign,
1358: LNS_ASSETS asset,
1359: LNS_LOOKUPS lkps1,
1360: LNS_LOOKUPS lkps2,
1361: LNS_LOOKUPS lkps3,
1362: LNS_LOOKUPS lkps4,
1363: LNS_LOOKUPS lkps5,
1364: LNS_LOOKUPS lkps6,
1365: HZ_PARTIES party,

Line 1362: LNS_LOOKUPS lkps4,

1358: LNS_ASSETS asset,
1359: LNS_LOOKUPS lkps1,
1360: LNS_LOOKUPS lkps2,
1361: LNS_LOOKUPS lkps3,
1362: LNS_LOOKUPS lkps4,
1363: LNS_LOOKUPS lkps5,
1364: LNS_LOOKUPS lkps6,
1365: HZ_PARTIES party,
1366: LNS_PARTICIPANTS par

Line 1363: LNS_LOOKUPS lkps5,

1359: LNS_LOOKUPS lkps1,
1360: LNS_LOOKUPS lkps2,
1361: LNS_LOOKUPS lkps3,
1362: LNS_LOOKUPS lkps4,
1363: LNS_LOOKUPS lkps5,
1364: LNS_LOOKUPS lkps6,
1365: HZ_PARTIES party,
1366: LNS_PARTICIPANTS par
1367: WHERE assetassign.asset_id = asset.asset_id and

Line 1364: LNS_LOOKUPS lkps6,

1360: LNS_LOOKUPS lkps2,
1361: LNS_LOOKUPS lkps3,
1362: LNS_LOOKUPS lkps4,
1363: LNS_LOOKUPS lkps5,
1364: LNS_LOOKUPS lkps6,
1365: HZ_PARTIES party,
1366: LNS_PARTICIPANTS par
1367: WHERE assetassign.asset_id = asset.asset_id and
1368: asset.asset_owner_id = par.hz_party_id and

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

1407: )
1408: )
1409: )
1410: )
1411: FROM LNS_FEE_ASSIGNMENTS lfa, LNS_FEES_ALL lf, LNS_LOOKUPS lkps1,
1412: LNS_LOOKUPS llkbo,
1413: LNS_LOOKUPS llkrt,
1414: LNS_LOOKUPS llkfc,
1415: fnd_lookups fl

Line 1412: LNS_LOOKUPS llkbo,

1408: )
1409: )
1410: )
1411: FROM LNS_FEE_ASSIGNMENTS lfa, LNS_FEES_ALL lf, LNS_LOOKUPS lkps1,
1412: LNS_LOOKUPS llkbo,
1413: LNS_LOOKUPS llkrt,
1414: LNS_LOOKUPS llkfc,
1415: fnd_lookups fl
1416: WHERE lfa.FEE_ID = lf.FEE_ID AND

Line 1413: LNS_LOOKUPS llkrt,

1409: )
1410: )
1411: FROM LNS_FEE_ASSIGNMENTS lfa, LNS_FEES_ALL lf, LNS_LOOKUPS lkps1,
1412: LNS_LOOKUPS llkbo,
1413: LNS_LOOKUPS llkrt,
1414: LNS_LOOKUPS llkfc,
1415: fnd_lookups fl
1416: WHERE lfa.FEE_ID = lf.FEE_ID AND
1417: lfa.loan_id = lh.loan_id and

Line 1414: LNS_LOOKUPS llkfc,

1410: )
1411: FROM LNS_FEE_ASSIGNMENTS lfa, LNS_FEES_ALL lf, LNS_LOOKUPS lkps1,
1412: LNS_LOOKUPS llkbo,
1413: LNS_LOOKUPS llkrt,
1414: LNS_LOOKUPS llkfc,
1415: fnd_lookups fl
1416: WHERE lfa.FEE_ID = lf.FEE_ID AND
1417: lfa.loan_id = lh.loan_id and
1418: llkfc.lookup_type = 'FEE_CATEGORY' and

Line 1441: LNS_LOOKUPS lkps1 , fnd_lookups fl

1437: )
1438: )
1439: )
1440: FROM LNS_COND_ASSIGNMENTS_VL lca, LNS_CONDITIONS_VL lc,
1441: LNS_LOOKUPS lkps1 , fnd_lookups fl
1442: WHERE lca.CONDITION_ID = lc.CONDITION_ID
1443: AND lkps1.lookup_type = 'CONDITION_TYPE'
1444: AND lkps1.lookup_code = lc.CONDITION_TYPE
1445: AND fl.lookup_type = 'YES_NO'

Line 1546: LNS_LOOKUPS lkps1,

1542: )
1543: )
1544: FROM LNS_FEE_ASSIGNMENTS lfa,
1545: LNS_FEES_ALL lf,
1546: LNS_LOOKUPS lkps1,
1547: LNS_LOOKUPS llkbo,
1548: LNS_LOOKUPS llkrt,
1549: LNS_LOOKUPS llkfc,
1550: fnd_lookups fl

Line 1547: LNS_LOOKUPS llkbo,

1543: )
1544: FROM LNS_FEE_ASSIGNMENTS lfa,
1545: LNS_FEES_ALL lf,
1546: LNS_LOOKUPS lkps1,
1547: LNS_LOOKUPS llkbo,
1548: LNS_LOOKUPS llkrt,
1549: LNS_LOOKUPS llkfc,
1550: fnd_lookups fl
1551: WHERE lfa.FEE_ID = lf.FEE_ID AND

Line 1548: LNS_LOOKUPS llkrt,

1544: FROM LNS_FEE_ASSIGNMENTS lfa,
1545: LNS_FEES_ALL lf,
1546: LNS_LOOKUPS lkps1,
1547: LNS_LOOKUPS llkbo,
1548: LNS_LOOKUPS llkrt,
1549: LNS_LOOKUPS llkfc,
1550: fnd_lookups fl
1551: WHERE lfa.FEE_ID = lf.FEE_ID AND
1552: lfa.disb_header_id = ldih.disb_header_id and

Line 1549: LNS_LOOKUPS llkfc,

1545: LNS_FEES_ALL lf,
1546: LNS_LOOKUPS lkps1,
1547: LNS_LOOKUPS llkbo,
1548: LNS_LOOKUPS llkrt,
1549: LNS_LOOKUPS llkfc,
1550: fnd_lookups fl
1551: WHERE lfa.FEE_ID = lf.FEE_ID AND
1552: lfa.disb_header_id = ldih.disb_header_id and
1553: llkfc.lookup_type = 'FEE_CATEGORY' and

Line 1576: LNS_LOOKUPS lkps1 , fnd_lookups fl

1572: )
1573: )
1574: )
1575: FROM LNS_COND_ASSIGNMENTS_VL lca, LNS_CONDITIONS_VL lc,
1576: LNS_LOOKUPS lkps1 , fnd_lookups fl
1577: WHERE lca.CONDITION_ID = lc.CONDITION_ID
1578: AND lkps1.lookup_type = 'CONDITION_TYPE'
1579: AND lkps1.lookup_code = lc.CONDITION_TYPE
1580: AND fl.lookup_type = 'YES_NO'

Line 1590: ,lns_lookups llkac

1586: )
1587: )
1588: )
1589: FROM lns_disb_headers ldih
1590: ,lns_lookups llkac
1591: WHERE ldih.loan_id = lh.loan_id and
1592: llkac.lookup_code = ldih.activity_code
1593: ), -- end of DISBURSEMENTS
1594: -- AMORTIZATION

Line 1644: lns_lookups llkrt,

1640: hz_party_sites site,
1641: hz_cust_acct_sites_all acct_site,
1642: --LNS_PAY_SUM_V pay, --Bug5262505
1643: xle_firstparty_information_v xle,
1644: lns_lookups llkrt,
1645: lns_lookups llktt,
1646: lns_loan_types_vl llt,
1647: lns_lookups llklc,
1648: lns_lookups llkp,

Line 1645: lns_lookups llktt,

1641: hz_cust_acct_sites_all acct_site,
1642: --LNS_PAY_SUM_V pay, --Bug5262505
1643: xle_firstparty_information_v xle,
1644: lns_lookups llkrt,
1645: lns_lookups llktt,
1646: lns_loan_types_vl llt,
1647: lns_lookups llklc,
1648: lns_lookups llkp,
1649: lns_lookups llkst,

Line 1647: lns_lookups llklc,

1643: xle_firstparty_information_v xle,
1644: lns_lookups llkrt,
1645: lns_lookups llktt,
1646: lns_loan_types_vl llt,
1647: lns_lookups llklc,
1648: lns_lookups llkp,
1649: lns_lookups llkst,
1650: lns_lookups llkdc,
1651: lns_lookups llkfq,

Line 1648: lns_lookups llkp,

1644: lns_lookups llkrt,
1645: lns_lookups llktt,
1646: lns_loan_types_vl llt,
1647: lns_lookups llklc,
1648: lns_lookups llkp,
1649: lns_lookups llkst,
1650: lns_lookups llkdc,
1651: lns_lookups llkfq,
1652: lns_lookups llkfqf,

Line 1649: lns_lookups llkst,

1645: lns_lookups llktt,
1646: lns_loan_types_vl llt,
1647: lns_lookups llklc,
1648: lns_lookups llkp,
1649: lns_lookups llkst,
1650: lns_lookups llkdc,
1651: lns_lookups llkfq,
1652: lns_lookups llkfqf,
1653: lns_lookups llkic,

Line 1650: lns_lookups llkdc,

1646: lns_loan_types_vl llt,
1647: lns_lookups llklc,
1648: lns_lookups llkp,
1649: lns_lookups llkst,
1650: lns_lookups llkdc,
1651: lns_lookups llkfq,
1652: lns_lookups llkfqf,
1653: lns_lookups llkic,
1654: jtf_rs_resource_extns res,

Line 1651: lns_lookups llkfq,

1647: lns_lookups llklc,
1648: lns_lookups llkp,
1649: lns_lookups llkst,
1650: lns_lookups llkdc,
1651: lns_lookups llkfq,
1652: lns_lookups llkfqf,
1653: lns_lookups llkic,
1654: jtf_rs_resource_extns res,
1655: lns_disb_headers ldh,

Line 1652: lns_lookups llkfqf,

1648: lns_lookups llkp,
1649: lns_lookups llkst,
1650: lns_lookups llkdc,
1651: lns_lookups llkfq,
1652: lns_lookups llkfqf,
1653: lns_lookups llkic,
1654: jtf_rs_resource_extns res,
1655: lns_disb_headers ldh,
1656: lns_loan_products_all_vl product

Line 1653: lns_lookups llkic,

1649: lns_lookups llkst,
1650: lns_lookups llkdc,
1651: lns_lookups llkfq,
1652: lns_lookups llkfqf,
1653: lns_lookups llkic,
1654: jtf_rs_resource_extns res,
1655: lns_disb_headers ldh,
1656: lns_loan_products_all_vl product
1657: where