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.JA_CN_COA_EXP_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 1499: ,HR_ORGANIZATION_INFORMATION HOI

1495: */
1496: ,nvl(PVSA.ADDRESS_LINE1, '') sup_addr
1497: BULK COLLECT INTO l_all_sup_city_addr
1498: FROM PO_VENDOR_SITES_ALL PVSA
1499: ,HR_ORGANIZATION_INFORMATION HOI
1500: WHERE --Check "Primary Pay" Vendor site of OUs under current LE
1501: HOI.org_information_context = 'Operating Unit Information'
1502: AND HOI.Org_Information2 = l_le_id --using variable l_le_id
1503: AND HOI.Org_Information3 = l_ledger_id --using variable l_ledger_id

Line 1534: ,HR_ORGANIZATION_INFORMATION HOI

1530: || nvl(PVC.PHONE, '') sup_phone
1531: BULK COLLECT INTO l_all_sup_phone
1532: FROM PO_VENDOR_CONTACTS PVC
1533: ,PO_VENDOR_SITES_ALL PVSA
1534: ,HR_ORGANIZATION_INFORMATION HOI
1535: WHERE PVC.vendor_site_id = PVSA.vendor_site_id
1536: --Check "Primary Pay" Vendor site of OUs under current LE
1537: AND HOI.org_information_context = 'Operating Unit Information'
1538: AND HOI.Org_Information2 = l_le_id --using variable l_le_id

Line 1623: ,HR_ORGANIZATION_INFORMATION HOI

1619: ,HZ_LOCATIONS LOC
1620: ,HZ_PARTY_SITES PARTY_SITE
1621: ,HZ_LOC_ASSIGNMENTS LOC_ASSIGN
1622: ,HZ_CUST_SITE_USES_ALL SU
1623: ,HR_ORGANIZATION_INFORMATION HOI
1624: WHERE --ADDR.CUST_ACCOUNT_ID alias CUSTOMER_ID in AR_ADDRESSES_V
1625: ADDR.CUST_ACCOUNT_ID = l_cust_account_id --using variable l_cust_account_id
1626: and ADDR.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1627: and LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID