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_LOCATIONS

Line 300: HZ_LOCATIONS ADDR,

296: SL.SOURCE_PROMOTION_ID,
297: TO_NUMBER(NULL)
298: FROM AS_SALES_LEADS SL,
299: HZ_CONTACT_POINTS PHONE,
300: HZ_LOCATIONS ADDR,
301: HZ_PARTY_SITES SITE,
302: HZ_PARTIES PARTY
303: WHERE SL.SALES_LEAD_ID = X_Sales_Lead_Id
304: AND SL.CUSTOMER_ID = PARTY.PARTY_ID

Line 945: HZ_LOCATIONS ADDR,

941: UPPER(PARTY.DUNS_NUMBER_C),
942: UPPER(SL.CHANNEL_CODE)
943: FROM AS_SALES_LEADS SL,
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

Line 2069: HZ_LOCATIONS ADDR,

2065: UPPER(PARTY.DUNS_NUMBER_C),
2066: UPPER(SL.CHANNEL_CODE)
2067: FROM AS_SALES_LEADS SL,
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