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.AS_SALES_LEAD_ASSIGN_PVT dependencies on HZ_ORGANIZATION_PROFILES

Line 948: HZ_ORGANIZATION_PROFILES ORGP

944: HZ_CONTACT_POINTS PHONE,
945: HZ_LOCATIONS ADDR,
946: HZ_PARTY_SITES SITE,
947: HZ_PARTIES PARTY,
948: HZ_ORGANIZATION_PROFILES ORGP
949: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id
950: AND SL.CUSTOMER_ID = PARTY.PARTY_ID
951: AND SL.ADDRESS_ID = SITE.PARTY_SITE_ID
952: AND PHONE.OWNER_TABLE_NAME(+) = c_hz_party_sites -- 'HZ_PARTY_SITES'

Line 998: HZ_ORGANIZATION_PROFILES ORGP

994: UPPER(SL.CHANNEL_CODE)
995: FROM AS_SALES_LEADS SL,
996: HZ_CONTACT_POINTS PHONE,
997: HZ_PARTIES PARTY,
998: HZ_ORGANIZATION_PROFILES ORGP
999: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id
1000: AND SL.CUSTOMER_ID = PARTY.PARTY_ID
1001: AND PHONE.OWNER_TABLE_NAME(+) = c_hz_parties --'HZ_PARTIES'
1002: AND PHONE.PRIMARY_FLAG(+) = c_y --'Y'

Line 2072: HZ_ORGANIZATION_PROFILES ORGP

2068: HZ_CONTACT_POINTS PHONE,
2069: HZ_LOCATIONS ADDR,
2070: HZ_PARTY_SITES SITE,
2071: HZ_PARTIES PARTY,
2072: HZ_ORGANIZATION_PROFILES ORGP
2073: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id
2074: AND SL.CUSTOMER_ID = PARTY.PARTY_ID
2075: AND SL.ADDRESS_ID = SITE.PARTY_SITE_ID
2076: AND PHONE.OWNER_TABLE_NAME(+) = c_hz_party_sites --'HZ_PARTY_SITES'

Line 2122: HZ_ORGANIZATION_PROFILES ORGP

2118: UPPER(SL.CHANNEL_CODE)
2119: FROM AS_SALES_LEADS SL,
2120: HZ_CONTACT_POINTS PHONE,
2121: HZ_PARTIES PARTY,
2122: HZ_ORGANIZATION_PROFILES ORGP
2123: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id
2124: AND SL.CUSTOMER_ID = PARTY.PARTY_ID
2125: AND PHONE.OWNER_TABLE_NAME(+) = c_hz_parties --'HZ_PARTIES'
2126: AND PHONE.PRIMARY_FLAG(+) = c_y --'Y'