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.JL_CO_GL_MG_MEDIA_PKG dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 1441: company_name xle_firstparty_information_v.name%TYPE;

1437: *************************************************************************/
1438:
1439: --p_location_id hr.hr_locations_all.location_id%TYPE := jg_zz_company_info.get_location_id;
1440:
1441: company_name xle_firstparty_information_v.name%TYPE;
1442: company_nit xle_firstparty_information_v.registration_number%TYPE;
1443: --company_vdigit hr.hr_locations_all.global_attribute12%TYPE;
1444: economic_activity_code xle_firstparty_information_v.activity_code%TYPE;
1445: company_address xle_firstparty_information_v.address_line_1%TYPE;

Line 1442: company_nit xle_firstparty_information_v.registration_number%TYPE;

1438:
1439: --p_location_id hr.hr_locations_all.location_id%TYPE := jg_zz_company_info.get_location_id;
1440:
1441: company_name xle_firstparty_information_v.name%TYPE;
1442: company_nit xle_firstparty_information_v.registration_number%TYPE;
1443: --company_vdigit hr.hr_locations_all.global_attribute12%TYPE;
1444: economic_activity_code xle_firstparty_information_v.activity_code%TYPE;
1445: company_address xle_firstparty_information_v.address_line_1%TYPE;
1446: area_code hr.hr_locations_all.telephone_number_1%TYPE;

Line 1444: economic_activity_code xle_firstparty_information_v.activity_code%TYPE;

1440:
1441: company_name xle_firstparty_information_v.name%TYPE;
1442: company_nit xle_firstparty_information_v.registration_number%TYPE;
1443: --company_vdigit hr.hr_locations_all.global_attribute12%TYPE;
1444: economic_activity_code xle_firstparty_information_v.activity_code%TYPE;
1445: company_address xle_firstparty_information_v.address_line_1%TYPE;
1446: area_code hr.hr_locations_all.telephone_number_1%TYPE;
1447: telephone_number hr.hr_locations_all.telephone_number_2%TYPE;
1448: city_code xle_firstparty_information_v.town_or_city%TYPE;

Line 1445: company_address xle_firstparty_information_v.address_line_1%TYPE;

1441: company_name xle_firstparty_information_v.name%TYPE;
1442: company_nit xle_firstparty_information_v.registration_number%TYPE;
1443: --company_vdigit hr.hr_locations_all.global_attribute12%TYPE;
1444: economic_activity_code xle_firstparty_information_v.activity_code%TYPE;
1445: company_address xle_firstparty_information_v.address_line_1%TYPE;
1446: area_code hr.hr_locations_all.telephone_number_1%TYPE;
1447: telephone_number hr.hr_locations_all.telephone_number_2%TYPE;
1448: city_code xle_firstparty_information_v.town_or_city%TYPE;
1449: identifi_register VARCHAR2(2000);

Line 1448: city_code xle_firstparty_information_v.town_or_city%TYPE;

1444: economic_activity_code xle_firstparty_information_v.activity_code%TYPE;
1445: company_address xle_firstparty_information_v.address_line_1%TYPE;
1446: area_code hr.hr_locations_all.telephone_number_1%TYPE;
1447: telephone_number hr.hr_locations_all.telephone_number_2%TYPE;
1448: city_code xle_firstparty_information_v.town_or_city%TYPE;
1449: identifi_register VARCHAR2(2000);
1450: movement_register VARCHAR2(2000);
1451: closed_register VARCHAR2(2000);
1452: count_literal NUMBER;

Line 1582: FROM xle_firstparty_information_v le,

1578: company_nit,
1579: --company_vdigit,
1580: city_code,
1581: economic_activity_code
1582: FROM xle_firstparty_information_v le,
1583: hr_locations hr
1584: WHERE le.legal_entity_id = p_legal_entity_id
1585: AND hr.location_id = le.location_id;
1586: