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 949: HZ_ORGANIZATION_PROFILES ORGP

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

Line 999: HZ_ORGANIZATION_PROFILES ORGP

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

Line 2073: HZ_ORGANIZATION_PROFILES ORGP

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

Line 2123: HZ_ORGANIZATION_PROFILES ORGP

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