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_PARTY_SITES

Line 301: HZ_PARTY_SITES SITE,

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
305: AND SL.ADDRESS_ID = SITE.PARTY_SITE_ID

Line 306: AND PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTY_SITES'

302: HZ_PARTIES PARTY
303: WHERE SL.SALES_LEAD_ID = X_Sales_Lead_Id
304: AND SL.CUSTOMER_ID = PARTY.PARTY_ID
305: AND SL.ADDRESS_ID = SITE.PARTY_SITE_ID
306: AND PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTY_SITES'
307: AND PHONE.PRIMARY_FLAG(+) = 'Y'
308: AND PHONE.STATUS(+) = 'A'
309: AND PHONE.CONTACT_POINT_TYPE(+) = 'PHONE'
310: AND SITE.PARTY_SITE_ID = PHONE.OWNER_TABLE_ID(+)

Line 913: CURSOR C_Get_Sales_Lead1(C_Sales_Lead_Id NUMBER, c_hz_party_sites VARCHAR2,

909: AND category = 'PARTNER';
910:
911: -- Bug 3035251
912: -- Add UPPER for all VARCHAR2 qualifiers
913: CURSOR C_Get_Sales_Lead1(C_Sales_Lead_Id NUMBER, c_hz_party_sites VARCHAR2,
914: c_status VARCHAR2, c_y VARCHAR2, c_phone VARCHAR2,
915: c_person VARCHAR2, c_organization VARCHAR2) IS
916: SELECT SL.SALES_LEAD_ID,
917: TO_NUMBER(NULL), -- sales_lead_line_id

Line 952: AND PHONE.OWNER_TABLE_NAME(+) = c_hz_party_sites -- 'HZ_PARTY_SITES'

948: HZ_ORGANIZATION_PROFILES ORGP
949: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id
950: AND SL.CUSTOMER_ID = PARTY.PARTY_ID
951: AND SL.ADDRESS_ID = SITE.PARTY_SITE_ID
952: AND PHONE.OWNER_TABLE_NAME(+) = c_hz_party_sites -- 'HZ_PARTY_SITES'
953: AND PHONE.PRIMARY_FLAG(+) = c_y --'Y'
954: AND PHONE.STATUS(+) = c_status
955: AND PHONE.CONTACT_POINT_TYPE(+) = c_phone --'PHONE'
956: AND SITE.PARTY_SITE_ID = PHONE.OWNER_TABLE_ID(+)

Line 1518: OPEN C_Get_Sales_Lead1(p_Sales_Lead_Id, 'HZ_PARTY_SITES', 'A',

1514: IF (AS_DEBUG_LOW_ON) THEN
1515: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1516: 'Open C_Get_Sales_Lead1');
1517: END IF;
1518: OPEN C_Get_Sales_Lead1(p_Sales_Lead_Id, 'HZ_PARTY_SITES', 'A',
1519: 'Y', 'PHONE', 'PERSON', 'ORGANIZATION');
1520: FETCH C_Get_Sales_Lead1 BULK COLLECT INTO
1521: l_lead_rec.SALES_LEAD_ID,
1522: l_lead_rec.SALES_LEAD_LINE_ID,

Line 2037: CURSOR C_Get_Sales_Lead1(C_Sales_Lead_Id NUMBER, c_hz_party_sites VARCHAR2,

2033: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id;
2034:
2035: -- Bug 3035251
2036: -- Add UPPER for all VARCHAR2 qualifiers
2037: CURSOR C_Get_Sales_Lead1(C_Sales_Lead_Id NUMBER, c_hz_party_sites VARCHAR2,
2038: c_status VARCHAR2, c_y VARCHAR2, c_phone VARCHAR2,
2039: c_person VARCHAR2, c_organization VARCHAR2) IS
2040: SELECT SL.SALES_LEAD_ID,
2041: TO_NUMBER(NULL), -- sales_lead_line_id

Line 2070: HZ_PARTY_SITES SITE,

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
2074: AND SL.CUSTOMER_ID = PARTY.PARTY_ID

Line 2076: AND PHONE.OWNER_TABLE_NAME(+) = c_hz_party_sites --'HZ_PARTY_SITES'

2072: HZ_ORGANIZATION_PROFILES ORGP
2073: WHERE SL.SALES_LEAD_ID = C_Sales_Lead_Id
2074: AND SL.CUSTOMER_ID = PARTY.PARTY_ID
2075: AND SL.ADDRESS_ID = SITE.PARTY_SITE_ID
2076: AND PHONE.OWNER_TABLE_NAME(+) = c_hz_party_sites --'HZ_PARTY_SITES'
2077: AND PHONE.PRIMARY_FLAG(+) = c_y --'Y'
2078: AND PHONE.STATUS(+) = c_status
2079: AND PHONE.CONTACT_POINT_TYPE(+) = c_phone --'PHONE'
2080: AND SITE.PARTY_SITE_ID = PHONE.OWNER_TABLE_ID(+)

Line 2569: OPEN C_Get_Sales_Lead1(p_Sales_Lead_Id, 'HZ_PARTY_SITES', 'A',

2565:
2566: IF l_new_address_id IS NOT NULL
2567: THEN
2568: -- Sales lead is created in party site level.
2569: OPEN C_Get_Sales_Lead1(p_Sales_Lead_Id, 'HZ_PARTY_SITES', 'A',
2570: 'Y', 'PHONE', 'PERSON', 'ORGANIZATION');
2571: FETCH C_Get_Sales_Lead1 BULK COLLECT INTO
2572: l_lead_rec.SALES_LEAD_ID,
2573: l_lead_rec.SALES_LEAD_LINE_ID,