APPS.QP_PRICE_BOOK_UTIL dependencies on HZ_PARTIES

Line 721: FROM hz_relationships rel, hz_parties party3,

717: INTO l_party_id_match
718: FROM dual
719: WHERE EXISTS (
720: SELECT 'x'
721: FROM hz_relationships rel, hz_parties party3,
722: hz_parties party4, hz_parties party5
723: WHERE rel.party_id = party5.party_id
724: AND party5.party_type = 'PARTY_RELATIONSHIP'
725: AND party5.status = 'A'

Line 722: hz_parties party4, hz_parties party5

718: FROM dual
719: WHERE EXISTS (
720: SELECT 'x'
721: FROM hz_relationships rel, hz_parties party3,
722: hz_parties party4, hz_parties party5
723: WHERE rel.party_id = party5.party_id
724: AND party5.party_type = 'PARTY_RELATIONSHIP'
725: AND party5.status = 'A'
726: AND trunc(rel.start_date) <= trunc(sysdate)

Line 734: AND rel.subject_table_name = 'HZ_PARTIES'

730: AND party3.status = 'A'
731: AND rel.object_id = party4.party_id
732: AND party4.party_type = 'ORGANIZATION'
733: AND party4.status = 'A'
734: AND rel.subject_table_name = 'HZ_PARTIES'
735: AND rel.object_table_name = 'HZ_PARTIES'
736: AND rel.relationship_id IN
737: (SELECT party_relationship_id
738: FROM hz_org_contacts org_con

Line 735: AND rel.object_table_name = 'HZ_PARTIES'

731: AND rel.object_id = party4.party_id
732: AND party4.party_type = 'ORGANIZATION'
733: AND party4.status = 'A'
734: AND rel.subject_table_name = 'HZ_PARTIES'
735: AND rel.object_table_name = 'HZ_PARTIES'
736: AND rel.relationship_id IN
737: (SELECT party_relationship_id
738: FROM hz_org_contacts org_con
739: WHERE rel.relationship_id =

Line 841: FROM hz_parties

837: --Check if Customer is valid
838: BEGIN
839: SELECT 1
840: INTO l_count
841: FROM hz_parties
842: WHERE party_id = p_pb_input_header_rec.customer_attr_value
843: AND rownum = 1;
844: EXCEPTION
845: WHEN OTHERS THEN

Line 1356: hz_parties hp, hz_party_sites hps, hz_locations hl

1352: SELECT 1
1353: INTO l_count
1354: FROM ecx_tp_headers eth, ecx_tp_details etd,
1355: ecx_ext_processes eep, ecx_transactions et,
1356: hz_parties hp, hz_party_sites hps, hz_locations hl
1357: WHERE eth.party_id = p_pb_input_header_rec.customer_attr_value
1358: AND eth.party_site_id = p_pb_input_header_rec.dlv_xml_site_id
1359: AND eth.tp_header_id = etd.tp_header_id
1360: AND etd.EXT_PROCESS_ID = eep.EXT_PROCESS_ID

Line 2546: from hz_parties

2542: RETURN NULL;
2543: ELSE
2544: BEGIN
2545: select party_name into l_customer_name
2546: from hz_parties
2547: where party_id = to_number(p_attribute_value_code);
2548: END;
2549: END IF;
2550: elsif (p_attribute_code = 'QUALIFIER_ATTRIBUTE1') then

Line 2569: FROM hz_parties where party_id = to_number(p_customer_id);

2565: RETURN null;
2566: else
2567: begin
2568: SELECT party_name INTO l_customer_name
2569: FROM hz_parties where party_id = to_number(p_customer_id);
2570: RETURN l_customer_name;
2571: EXCEPTION
2572: WHEN no_data_found THEN RETURN null;
2573: end;

Line 2744: HZ_PARTIES HZP, HZ_CUST_ACCOUNTS HZC, (SELECT LOC.COUNTRY,

2740: BEGIN
2741: SELECT MCI.CUSTOMER_ITEM_DESC
2742: INTO l_customer_item_desc
2743: FROM MTL_CUSTOMER_ITEMS MCI,
2744: HZ_PARTIES HZP, HZ_CUST_ACCOUNTS HZC, (SELECT LOC.COUNTRY,
2745: ACCT_SITE.CUST_ACCT_SITE_ID ADDRESS_ID
2746: FROM HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
2747: HZ_LOCATIONS LOC, HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
2748: HZ_PARTY_SITES PARTY_SITE