APPS.INV_LABEL_PVT8 dependencies on HZ_PARTIES

Line 972: FROM hz_parties party

968:
969: CURSOR c_customer(p_customer_id NUMBER) IS
970: SELECT substrb(party.party_name,1,50) customer_name,
971: cust_acct.account_number customer_number
972: FROM hz_parties party
973: , hz_cust_accounts cust_acct
974: WHERE cust_acct.party_id = party.party_id
975: AND cust_acct.cust_account_id = p_customer_id;
976:

Line 1089: hz_parties PARTY,

1085: FROM ( SELECT ACCT_ROLE.cust_account_role_id contact_id,
1086: SUBSTRB(PARTY.person_last_name,1,50) last_name,
1087: SUBSTRB(PARTY.person_first_name,1,40) first_name
1088: FROM hz_cust_account_roles ACCT_ROLE,
1089: hz_parties PARTY,
1090: hz_relationships REL,
1091: hz_cust_accounts ROLE_ACCT
1092: WHERE
1093: ACCT_ROLE.party_id = REL.party_id

Line 1096: AND REL.subject_table_name = 'HZ_PARTIES'

1092: WHERE
1093: ACCT_ROLE.party_id = REL.party_id
1094: AND ACCT_ROLE.role_type = 'CONTACT'
1095: AND REL.subject_id = PARTY.party_id
1096: AND REL.subject_table_name = 'HZ_PARTIES'
1097: AND REL.object_table_name = 'HZ_PARTIES'
1098: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1099: AND ROLE_ACCT.party_id = REL.object_id
1100: ) ra_cont

Line 1097: AND REL.object_table_name = 'HZ_PARTIES'

1093: ACCT_ROLE.party_id = REL.party_id
1094: AND ACCT_ROLE.role_type = 'CONTACT'
1095: AND REL.subject_id = PARTY.party_id
1096: AND REL.subject_table_name = 'HZ_PARTIES'
1097: AND REL.object_table_name = 'HZ_PARTIES'
1098: AND ACCT_ROLE.cust_account_id = ROLE_ACCT.cust_account_id
1099: AND ROLE_ACCT.party_id = REL.object_id
1100: ) ra_cont
1101: WHERE ra_cont.contact_id = p_contact_id;