APPS.AS_SALES_LEAD_ASSIGN_PVT dependencies on HZ_CONTACT_POINTS

Line 299: HZ_CONTACT_POINTS PHONE,

295: TRUNC(SL.CREATION_DATE),
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

Line 341: HZ_CONTACT_POINTS PHONE,

337: TRUNC(SL.CREATION_DATE),
338: SL.SOURCE_PROMOTION_ID,
339: NULL
340: FROM AS_SALES_LEADS SL,
341: HZ_CONTACT_POINTS PHONE,
342: HZ_PARTIES PARTY
343: WHERE SL.SALES_LEAD_ID = X_Sales_Lead_Id
344: AND SL.CUSTOMER_ID = PARTY.PARTY_ID
345: AND PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

Line 944: HZ_CONTACT_POINTS PHONE,

940: UPPER(ORGP.PREF_FUNCTIONAL_CURRENCY),
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

Line 996: HZ_CONTACT_POINTS PHONE,

992: UPPER(ORGP.PREF_FUNCTIONAL_CURRENCY),
993: UPPER(PARTY.DUNS_NUMBER_C),
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

Line 2068: HZ_CONTACT_POINTS PHONE,

2064: UPPER(ORGP.PREF_FUNCTIONAL_CURRENCY),
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

Line 2120: HZ_CONTACT_POINTS PHONE,

2116: UPPER(ORGP.PREF_FUNCTIONAL_CURRENCY),
2117: UPPER(PARTY.DUNS_NUMBER_C),
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