DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_ASSIGN_PVT dependencies on HZ_LOCATIONS

Line 301: HZ_LOCATIONS ADDR,

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

Line 946: HZ_LOCATIONS ADDR,

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

Line 2070: HZ_LOCATIONS ADDR,

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