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 302: HZ_PARTY_SITES SITE,

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

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

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

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

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

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

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

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

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

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

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

Line 2071: HZ_PARTY_SITES SITE,

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

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

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

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

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