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_PARTIES

Line 302: HZ_PARTIES PARTY

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
306: AND PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTY_SITES'

Line 342: HZ_PARTIES PARTY

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'
346: AND PHONE.PRIMARY_FLAG(+) = 'Y'

Line 345: AND PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

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'
346: AND PHONE.PRIMARY_FLAG(+) = 'Y'
347: AND PHONE.STATUS(+) = 'A'
348: AND PHONE.CONTACT_POINT_TYPE(+) = 'PHONE'
349: AND PARTY.PARTY_ID = PHONE.OWNER_TABLE_ID(+)

Line 895: FROM hz_parties

891: WHERE partner_id = c_partner_id;
892:
893: CURSOR C_Get_Partner_Name(c_referred_by NUMBER) IS
894: SELECT party_name
895: FROM hz_parties
896: WHERE party_id = c_referred_by;
897:
898: -- If resource is partner user, source_id is party_id of the
899: -- relationship.

Line 947: HZ_PARTIES PARTY,

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
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

Line 965: CURSOR C_Get_Sales_Lead2(C_Sales_Lead_Id NUMBER, c_hz_parties VARCHAR2,

961: AND NVL(ORGP.EFFECTIVE_END_DATE(+),SYSDATE + 1) > SYSDATE;
962:
963: -- Bug 3035251
964: -- Add UPPER for all VARCHAR2 qualifiers
965: CURSOR C_Get_Sales_Lead2(C_Sales_Lead_Id NUMBER, c_hz_parties VARCHAR2,
966: c_status VARCHAR2, c_y VARCHAR2, c_phone VARCHAR2,
967: c_person VARCHAR2, c_organization VARCHAR2) IS
968: SELECT SL.SALES_LEAD_ID,
969: TO_NUMBER(NULL), -- sales_lead_line_id

Line 997: HZ_PARTIES PARTY,

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
1001: AND PHONE.OWNER_TABLE_NAME(+) = c_hz_parties --'HZ_PARTIES'

Line 1001: AND PHONE.OWNER_TABLE_NAME(+) = c_hz_parties --'HZ_PARTIES'

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
1001: AND PHONE.OWNER_TABLE_NAME(+) = c_hz_parties --'HZ_PARTIES'
1002: AND PHONE.PRIMARY_FLAG(+) = c_y --'Y'
1003: AND PHONE.STATUS(+) = c_status
1004: AND PHONE.CONTACT_POINT_TYPE(+) = c_phone --'PHONE'
1005: AND PARTY.PARTY_ID = PHONE.OWNER_TABLE_ID(+)

Line 1555: OPEN C_Get_Sales_Lead2(p_Sales_Lead_Id, 'HZ_PARTIES', 'A',

1551: IF (AS_DEBUG_LOW_ON) THEN
1552: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1553: 'Open C_Get_Sales_Lead2');
1554: END IF;
1555: OPEN C_Get_Sales_Lead2(p_Sales_Lead_Id, 'HZ_PARTIES', 'A',
1556: 'Y', 'PHONE', 'PERSON', 'ORGANIZATION');
1557: FETCH C_Get_Sales_Lead2 BULK COLLECT INTO
1558: l_lead_rec.SALES_LEAD_ID,
1559: l_lead_rec.SALES_LEAD_LINE_ID,

Line 2071: HZ_PARTIES PARTY,

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

Line 2089: CURSOR C_Get_Sales_Lead2(C_Sales_Lead_Id NUMBER, c_hz_parties VARCHAR2,

2085: AND NVL(ORGP.EFFECTIVE_END_DATE(+),SYSDATE + 1) > SYSDATE;
2086:
2087: -- Bug 3035251
2088: -- Add UPPER for all VARCHAR2 qualifiers
2089: CURSOR C_Get_Sales_Lead2(C_Sales_Lead_Id NUMBER, c_hz_parties VARCHAR2,
2090: c_status VARCHAR2, c_y VARCHAR2, c_phone VARCHAR2,
2091: c_person VARCHAR2, c_organization VARCHAR2) IS
2092: SELECT SL.SALES_LEAD_ID,
2093: TO_NUMBER(NULL), -- sales_lead_line_id

Line 2121: HZ_PARTIES PARTY,

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
2125: AND PHONE.OWNER_TABLE_NAME(+) = c_hz_parties --'HZ_PARTIES'

Line 2125: AND PHONE.OWNER_TABLE_NAME(+) = c_hz_parties --'HZ_PARTIES'

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
2125: AND PHONE.OWNER_TABLE_NAME(+) = c_hz_parties --'HZ_PARTIES'
2126: AND PHONE.PRIMARY_FLAG(+) = c_y --'Y'
2127: AND PHONE.STATUS(+) = c_status
2128: AND PHONE.CONTACT_POINT_TYPE(+) = c_phone --'PHONE'
2129: AND PARTY.PARTY_ID = PHONE.OWNER_TABLE_ID(+)

Line 2602: OPEN C_Get_Sales_Lead2(p_Sales_Lead_Id, 'HZ_PARTIES', 'A',

2598: l_lead_rec.SQUAL_CHAR30;
2599: CLOSE C_Get_Sales_Lead1;
2600: ELSE
2601: -- Sales lead is created in party level.
2602: OPEN C_Get_Sales_Lead2(p_Sales_Lead_Id, 'HZ_PARTIES', 'A',
2603: 'Y', 'PHONE', 'PERSON', 'ORGANIZATION');
2604: FETCH C_Get_Sales_Lead2 BULK COLLECT INTO
2605: l_lead_rec.SALES_LEAD_ID,
2606: l_lead_rec.SALES_LEAD_LINE_ID,