[Home] [Help]
296: TRUNC(SL.CREATION_DATE),
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
338: TRUNC(SL.CREATION_DATE),
339: SL.SOURCE_PROMOTION_ID,
340: NULL
341: FROM AS_SALES_LEADS SL,
342: HZ_CONTACT_POINTS PHONE,
343: HZ_PARTIES PARTY
344: WHERE SL.SALES_LEAD_ID = X_Sales_Lead_Id
345: AND SL.CUSTOMER_ID = PARTY.PARTY_ID
346: AND PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
941: UPPER(ORGP.PREF_FUNCTIONAL_CURRENCY),
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
993: UPPER(ORGP.PREF_FUNCTIONAL_CURRENCY),
994: UPPER(PARTY.DUNS_NUMBER_C),
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
2065: UPPER(ORGP.PREF_FUNCTIONAL_CURRENCY),
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
2117: UPPER(ORGP.PREF_FUNCTIONAL_CURRENCY),
2118: UPPER(PARTY.DUNS_NUMBER_C),
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