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 XLE_ENTITY_PROFILES

Line 209: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;

205: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
206: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
207: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
208: l_loan_type_id lns_loan_types.loan_type_id%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;

Line 210: l_legal_entity_name xle_entity_profiles.name%TYPE;

206: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
207: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
208: l_loan_type_id lns_loan_types.loan_type_id%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;

Line 415: FROM xle_entity_profiles

411: IF legal_entity_id is NOT NULL
412: THEN
413: SELECT NAME
414: INTO l_legal_entity_name
415: FROM xle_entity_profiles
416: WHERE legal_entity_id = l_legal_entity_id;
417: END IF;
418: IF product_id is NOT NULL
419: THEN

Line 575: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;

571: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
572: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
573: l_loan_type_desc lns_loan_types.loan_type_desc%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;

Line 576: l_legal_entity_name xle_entity_profiles.name%TYPE;

572: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
573: l_loan_type_desc lns_loan_types.loan_type_desc%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);

Line 790: 'xle_entity_profiles le, ' ||

786: 'fnd_territories_vl terr, ' ||
787: 'hz_party_sites site, ' ||
788: 'hz_cust_acct_sites_all acct_site, ' ||
789: 'lns_loan_products_vl product, ' ||
790: 'xle_entity_profiles le, ' ||
791: 'hr_operating_units ou, ' ||
792: 'lns_loan_types_vl lot ' ||
793: 'where ' ||
794: 'lh.primary_borrower_id = hp.party_id and ' ||

Line 886: FROM xle_entity_profiles

882: IF legal_entity_id is NOT NULL
883: THEN
884: SELECT NAME
885: INTO l_legal_entity_name
886: FROM xle_entity_profiles
887: WHERE legal_entity_id = l_legal_entity_id;
888: END IF;
889: IF loan_assigned_to is NOT NULL
890: THEN