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 303: HZ_PARTIES PARTY

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

Line 343: HZ_PARTIES PARTY

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

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

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

Line 896: FROM hz_parties

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

Line 948: HZ_PARTIES PARTY,

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

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

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

Line 998: HZ_PARTIES PARTY,

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

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

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

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

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

Line 2072: HZ_PARTIES PARTY,

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

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

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

Line 2122: HZ_PARTIES PARTY,

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

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

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

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

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