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.CSI_PARTY_RELATIONSHIPS_PVT dependencies on HZ_PARTIES

Line 1689: -- Verify if the party_id is valid from HZ_parties,PO_vendors and employee tables

1685: p_party_source_tbl(p_party_count_rec.party_source_count).valid_flag := 'Y';
1686: END IF;
1687: END IF;
1688:
1689: -- Verify if the party_id is valid from HZ_parties,PO_vendors and employee tables
1690: -- based on the value of party_source_table
1691: -- Check the cache before hitting the database.
1692: l_exists_flag := 'N';
1693: l_valid_flag := 'Y';

Line 7438: IF upper(p_party_tbl) = 'HZ_PARTIES'

7434: RAISE fnd_api.g_exc_error;
7435: END IF;
7436:
7437:
7438: IF upper(p_party_tbl) = 'HZ_PARTIES'
7439: THEN
7440: BEGIN
7441:
7442: SELECT hp.party_name party_name,

Line 7505: HZ_PARTIES HP,

7501: x_contact_details.country,
7502: x_contact_details.email
7503:
7504: FROM
7505: HZ_PARTIES HP,
7506: CSI_I_PARTIES CIP,
7507: -- CSI_IPA_RELATION_TYPES CIR,
7508: HZ_CONTACT_POINTS HCP_WP,
7509: HZ_CONTACT_POINTS HCP_HP,

Line 7523: AND CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES'

7519: AND CIP.CONTACT_IP_ID = CIPO.INSTANCE_PARTY_ID
7520: AND CIPO.PARTY_ID = HR.OBJECT_ID
7521: AND HR.SUBJECT_ID = HP.PARTY_ID
7522: AND CIP.CONTACT_FLAG = 'Y'
7523: AND CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES'
7524: -- AND CIP.RELATIONSHIP_TYPE_CODE = CIR.IPA_RELATION_TYPE_CODE(+)
7525: -- AND CL.LOOKUP_CODE(+) = CIP.PARTY_SOURCE_TABLE
7526: AND HR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7527: AND HR.OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 7526: AND HR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

7522: AND CIP.CONTACT_FLAG = 'Y'
7523: AND CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES'
7524: -- AND CIP.RELATIONSHIP_TYPE_CODE = CIR.IPA_RELATION_TYPE_CODE(+)
7525: -- AND CL.LOOKUP_CODE(+) = CIP.PARTY_SOURCE_TABLE
7526: AND HR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7527: AND HR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7528:
7529: AND HCP_WP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
7530: AND HCP_WP.OWNER_TABLE_ID(+) = HR.PARTY_ID

Line 7527: AND HR.OBJECT_TABLE_NAME = 'HZ_PARTIES'

7523: AND CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES'
7524: -- AND CIP.RELATIONSHIP_TYPE_CODE = CIR.IPA_RELATION_TYPE_CODE(+)
7525: -- AND CL.LOOKUP_CODE(+) = CIP.PARTY_SOURCE_TABLE
7526: AND HR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7527: AND HR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7528:
7529: AND HCP_WP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
7530: AND HCP_WP.OWNER_TABLE_ID(+) = HR.PARTY_ID
7531: AND HCP_WP.CONTACT_POINT_TYPE(+) = 'PHONE'

Line 7529: AND HCP_WP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

7525: -- AND CL.LOOKUP_CODE(+) = CIP.PARTY_SOURCE_TABLE
7526: AND HR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
7527: AND HR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
7528:
7529: AND HCP_WP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
7530: AND HCP_WP.OWNER_TABLE_ID(+) = HR.PARTY_ID
7531: AND HCP_WP.CONTACT_POINT_TYPE(+) = 'PHONE'
7532: AND HCP_WP.PHONE_LINE_TYPE(+) = 'GEN'
7533: AND HCP_WP.CONTACT_POINT_PURPOSE(+) = 'BUSINESS'

Line 7535: AND HCP_HP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

7531: AND HCP_WP.CONTACT_POINT_TYPE(+) = 'PHONE'
7532: AND HCP_WP.PHONE_LINE_TYPE(+) = 'GEN'
7533: AND HCP_WP.CONTACT_POINT_PURPOSE(+) = 'BUSINESS'
7534:
7535: AND HCP_HP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
7536: AND HCP_HP.OWNER_TABLE_ID(+) = HR.PARTY_ID
7537: AND HCP_HP.CONTACT_POINT_TYPE(+) = 'PHONE'
7538: AND HCP_HP.PHONE_LINE_TYPE(+) = 'GEN'
7539: AND HCP_HP.CONTACT_POINT_PURPOSE(+) = 'PERSONAL'

Line 7541: AND HCP_MB.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

7537: AND HCP_HP.CONTACT_POINT_TYPE(+) = 'PHONE'
7538: AND HCP_HP.PHONE_LINE_TYPE(+) = 'GEN'
7539: AND HCP_HP.CONTACT_POINT_PURPOSE(+) = 'PERSONAL'
7540:
7541: AND HCP_MB.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
7542: AND HCP_MB.OWNER_TABLE_ID(+) = HR.PARTY_ID
7543: AND HCP_MB.CONTACT_POINT_TYPE(+) = 'PHONE'
7544: AND HCP_MB.PHONE_LINE_TYPE(+) = 'MOBILE'
7545: AND HCP_MB.CONTACT_POINT_PURPOSE(+) = 'BUSINESS'

Line 7547: AND HCP_PG.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

7543: AND HCP_MB.CONTACT_POINT_TYPE(+) = 'PHONE'
7544: AND HCP_MB.PHONE_LINE_TYPE(+) = 'MOBILE'
7545: AND HCP_MB.CONTACT_POINT_PURPOSE(+) = 'BUSINESS'
7546:
7547: AND HCP_PG.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
7548: AND HCP_PG.OWNER_TABLE_ID(+) = HR.PARTY_ID
7549: AND HCP_PG.CONTACT_POINT_TYPE(+) = 'PHONE'
7550: AND HCP_PG.PHONE_LINE_TYPE(+) = 'PAGER'
7551: AND HCP_PG.CONTACT_POINT_PURPOSE(+) = 'BUSINESS'

Line 7553: AND HCP_FX.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

7549: AND HCP_PG.CONTACT_POINT_TYPE(+) = 'PHONE'
7550: AND HCP_PG.PHONE_LINE_TYPE(+) = 'PAGER'
7551: AND HCP_PG.CONTACT_POINT_PURPOSE(+) = 'BUSINESS'
7552:
7553: AND HCP_FX.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
7554: AND HCP_FX.OWNER_TABLE_ID(+) = HR.PARTY_ID
7555: AND HCP_FX.CONTACT_POINT_TYPE(+) = 'PHONE'
7556: AND HCP_FX.PHONE_LINE_TYPE(+) = 'FAX'
7557: AND HCP_FX.CONTACT_POINT_PURPOSE(+) = 'BUSINESS'

Line 7559: AND HCP_EM.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

7555: AND HCP_FX.CONTACT_POINT_TYPE(+) = 'PHONE'
7556: AND HCP_FX.PHONE_LINE_TYPE(+) = 'FAX'
7557: AND HCP_FX.CONTACT_POINT_PURPOSE(+) = 'BUSINESS'
7558:
7559: AND HCP_EM.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
7560: AND HCP_EM.OWNER_TABLE_ID(+) = HR.PARTY_ID
7561: AND HCP_EM.CONTACT_POINT_TYPE(+) = 'EMAIL'
7562: AND HCP_EM.PRIMARY_FLAG(+) = 'Y'
7563: AND ROWNUM < 2;

Line 8122: ELSIF x_party_history_tbl(i).old_party_source_table = 'HZ_PARTIES' THEN

8118: EXCEPTION
8119: WHEN OTHERS THEN
8120: NULL;
8121: END;
8122: ELSIF x_party_history_tbl(i).old_party_source_table = 'HZ_PARTIES' THEN
8123: BEGIN
8124: SELECT party_number,
8125: 'PARTY'
8126: INTO x_party_history_tbl(i).old_contact_party_number,

Line 8128: FROM hz_parties

8124: SELECT party_number,
8125: 'PARTY'
8126: INTO x_party_history_tbl(i).old_contact_party_number,
8127: x_party_history_tbl(i).old_contact_party_type
8128: FROM hz_parties
8129: WHERE party_id = l_old_contact_party_id;
8130: EXCEPTION
8131: WHEN OTHERS THEN
8132: NULL;

Line 8203: ELSIF x_party_history_tbl(i).old_party_source_table = 'HZ_PARTIES' THEN

8199: EXCEPTION
8200: WHEN OTHERS THEN
8201: NULL;
8202: END;
8203: ELSIF x_party_history_tbl(i).old_party_source_table = 'HZ_PARTIES' THEN
8204: BEGIN
8205: SELECT party_number,
8206: 'PARTY',
8207: party_name

Line 8211: FROM hz_parties

8207: party_name
8208: INTO x_party_history_tbl(i).old_party_number,
8209: x_party_history_tbl(i).old_party_type,
8210: x_party_history_tbl(i).old_party_name
8211: FROM hz_parties
8212: WHERE party_id = x_party_history_tbl(i).old_party_id;
8213: EXCEPTION
8214: WHEN OTHERS THEN
8215: NULL;

Line 8314: ELSIF x_party_history_tbl(i).new_party_source_table = 'HZ_PARTIES' THEN

8310: EXCEPTION
8311: WHEN OTHERS THEN
8312: NULL;
8313: END;
8314: ELSIF x_party_history_tbl(i).new_party_source_table = 'HZ_PARTIES' THEN
8315: BEGIN
8316: SELECT party_number,
8317: 'PARTY'
8318: INTO x_party_history_tbl(i).new_contact_party_number,

Line 8320: FROM hz_parties

8316: SELECT party_number,
8317: 'PARTY'
8318: INTO x_party_history_tbl(i).new_contact_party_number,
8319: x_party_history_tbl(i).new_contact_party_type
8320: FROM hz_parties
8321: WHERE party_id = l_new_contact_party_id;
8322: EXCEPTION
8323: WHEN OTHERS THEN
8324: NULL;

Line 8396: ELSIF x_party_history_tbl(i).new_party_source_table = 'HZ_PARTIES' THEN

8392: EXCEPTION
8393: WHEN OTHERS THEN
8394: NULL;
8395: END;
8396: ELSIF x_party_history_tbl(i).new_party_source_table = 'HZ_PARTIES' THEN
8397: BEGIN
8398: SELECT party_number,
8399: 'PARTY',
8400: party_name

Line 8404: FROM hz_parties

8400: party_name
8401: INTO x_party_history_tbl(i).new_party_number,
8402: x_party_history_tbl(i).new_party_type,
8403: x_party_history_tbl(i).new_party_name
8404: FROM hz_parties
8405: WHERE party_id = x_party_history_tbl(i).new_party_id;
8406: EXCEPTION
8407: WHEN OTHERS THEN
8408: NULL;