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 1497: ,HR_ORGANIZATION_INFORMATION HOI

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

Line 1532: ,HR_ORGANIZATION_INFORMATION HOI

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

Line 1621: ,HR_ORGANIZATION_INFORMATION HOI

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