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

Line 652: FROM hz_parties

648: lv_exists_flag VARCHAR2(1) := 'N';
649:
650: CURSOR c_party IS
651: SELECT 'Y'
652: FROM hz_parties
653: WHERE party_id = p_party_id
654: AND nvl(status, 'A') = 'A';
655:
656: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'is_party_valid';

Line 759: FROM hz_parties

755: --Check the party_type for the given party
756:
757: CURSOR c_party_type(p_party_id in number) IS
758: SELECT party_type
759: FROM hz_parties
760: WHERE party_id = p_party_id;
761:
762: CURSOR c_contact_org(p_party_id in number,
763: p_contact_id in number) IS

Line 766: hz_parties sub,

762: CURSOR c_contact_org(p_party_id in number,
763: p_contact_id in number) IS
764: SELECT rel.party_id
765: FROM hz_relationships party_rel,
766: hz_parties sub,
767: hz_parties rel,
768: ar_lookups ar,
769: ar_lookups relm,
770: hz_relationship_types typ,

Line 767: hz_parties rel,

763: p_contact_id in number) IS
764: SELECT rel.party_id
765: FROM hz_relationships party_rel,
766: hz_parties sub,
767: hz_parties rel,
768: ar_lookups ar,
769: ar_lookups relm,
770: hz_relationship_types typ,
771: hz_code_assignments asg

Line 791: AND party_rel.subject_table_name = 'HZ_PARTIES'

787: AND asg.class_category = 'RELATIONSHIP_TYPE_GROUP'
788: AND asg.class_code = 'PARTY_REL_GRP_CONTACTS'
789: AND typ.relationship_type = party_rel.relationship_type
790: AND party_rel.subject_type = 'PERSON'
791: AND party_rel.subject_table_name = 'HZ_PARTIES'
792: AND party_rel.object_type = 'ORGANIZATION'
793: AND party_rel.object_table_name = 'HZ_PARTIES'
794: AND party_rel.relationship_code = typ.forward_rel_code;
795:

Line 793: AND party_rel.object_table_name = 'HZ_PARTIES'

789: AND typ.relationship_type = party_rel.relationship_type
790: AND party_rel.subject_type = 'PERSON'
791: AND party_rel.subject_table_name = 'HZ_PARTIES'
792: AND party_rel.object_type = 'ORGANIZATION'
793: AND party_rel.object_table_name = 'HZ_PARTIES'
794: AND party_rel.relationship_code = typ.forward_rel_code;
795:
796:
797: CURSOR c_contact_person(p_party_id number,p_contact_id number) IS

Line 799: FROM Hz_Parties sub,

795:
796:
797: CURSOR c_contact_person(p_party_id number,p_contact_id number) IS
798: SELECT sub.party_id
799: FROM Hz_Parties sub,
800: Hz_Relationships r
801: WHERE r.object_id = p_party_id
802: AND r.party_id = p_contact_id
803: AND sub.status = 'A'

Line 814: hz_parties sub,

810:
811: /*CURSOR c_contact_person(p_party_id number,p_contact_id number) IS
812: SELECT rel.party_id
813: FROM hz_relationships party_rel,
814: hz_parties sub,
815: hz_parties rel,
816: ar_lookups ar,
817: ar_lookups relm,
818: hz_relationship_types typ,

Line 815: hz_parties rel,

811: /*CURSOR c_contact_person(p_party_id number,p_contact_id number) IS
812: SELECT rel.party_id
813: FROM hz_relationships party_rel,
814: hz_parties sub,
815: hz_parties rel,
816: ar_lookups ar,
817: ar_lookups relm,
818: hz_relationship_types typ,
819: hz_code_assignments asg

Line 838: AND party_rel.subject_table_name = 'HZ_PARTIES'

834: AND asg.class_category = 'RELATIONSHIP_TYPE_GROUP'
835: AND asg.class_code = 'PARTY_REL_GRP_CONTACTS'
836: AND typ.relationship_type = party_rel.relationship_type
837: AND party_rel.subject_type = 'PERSON'
838: AND party_rel.subject_table_name = 'HZ_PARTIES'
839: AND party_rel.object_type = 'PERSON' -- added for bug # 4744186
840: AND party_rel.object_table_name = 'HZ_PARTIES'
841: AND party_rel.relationship_code = typ.forward_rel_code;
842: */

Line 840: AND party_rel.object_table_name = 'HZ_PARTIES'

836: AND typ.relationship_type = party_rel.relationship_type
837: AND party_rel.subject_type = 'PERSON'
838: AND party_rel.subject_table_name = 'HZ_PARTIES'
839: AND party_rel.object_type = 'PERSON' -- added for bug # 4744186
840: AND party_rel.object_table_name = 'HZ_PARTIES'
841: AND party_rel.relationship_code = typ.forward_rel_code;
842: */
843: lv_exists_flag VARCHAR2(1) := 'N';
844: lv_party_type VARCHAR2(30);

Line 924: HZ_PARTIES party

920: p_party_id IN NUMBER) IS
921: SELECT site.party_site_id
922: FROM HZ_PARTY_SITES site,
923: HZ_PARTY_SITE_USES site_use,
924: HZ_PARTIES party
925: WHERE site.party_site_id = p_party_site_id
926: AND site.party_id = p_party_id
927: AND site.party_id = party.party_id
928: AND site.party_site_id = site_use.party_site_id

Line 939: HZ_PARTIES party

935: p_party_id IN NUMBER) IS
936: SELECT site.party_site_id
937: FROM HZ_PARTY_SITES site,
938: HZ_PARTY_SITE_USES site_use,
939: HZ_PARTIES party
940: WHERE site.party_site_id = p_party_site_id
941: AND site.party_id = p_party_id
942: AND site.party_id = party.party_id
943: AND site.party_site_id = site_use.party_site_id

Line 952: HZ_PARTIES party

948: p_party_id IN NUMBER) IS
949:
950: SELECT site.party_site_id
951: FROM HZ_PARTY_SITES site,
952: HZ_PARTIES party
953: WHERE site.party_site_id = p_party_site_id
954: AND site.party_id = p_party_id
955: AND site.party_id = party.party_id
956: AND nvl(site.status, 'A') = 'A';

Line 1297: CP.OWNER_PARTY_SOURCE_TABLE = 'HZ_PARTIES' AND

1293: SELECT 'Y'
1294: FROM CSI_ITEM_INSTANCES cp,
1295: MTL_SYSTEM_ITEMS_KFV ITEMS
1296: WHERE cp.instance_id = p_instance_id AND
1297: CP.OWNER_PARTY_SOURCE_TABLE = 'HZ_PARTIES' AND
1298: -- cp.owner_party_id = p_party_id AND Commented for bug 8552188
1299: ITEMS.INVENTORY_ITEM_ID = CP.INVENTORY_ITEM_ID AND
1300: ITEMS.ORGANIZATION_ID = cs_std.get_item_valdn_orgzn_id AND
1301: exists (select 'x'

Line 1305: and cip.party_source_table = 'HZ_PARTIES')AND

1301: exists (select 'x'
1302: from csi_i_parties cip
1303: where cip.party_id = p_party_id
1304: and cip.instance_id = cp.instance_id
1305: and cip.party_source_table = 'HZ_PARTIES')AND
1306: (
1307: (fnd_profile.value('CS_SR_RESTRICT_IB') = 'YES'
1308: and CP.LOCATION_TYPE_CODE IN('HZ_PARTY_SITES','HZ_LOCATIONS'))
1309: or (fnd_profile.value('CS_SR_RESTRICT_IB') <> 'YES'));

Line 14941: hz_parties hzp,

14937: inc.caller_type
14938: FROM cs_incidents_all_b inc,
14939: CS_INCIDENT_TYPES intp,
14940: CS_BUSINESS_PROCESSES bp,
14941: hz_parties hzp,
14942: hz_cust_accounts hza
14943: WHERE inc.incident_id = p_incident_id
14944: AND inc.incident_type_id = intp.incident_type_id
14945: AND intp.business_process_id = bp.business_process_id

Line 15718: HZ_PARTIES party

15714: P_PARTY_ID IN NUMBER) IS
15715: SELECT site_use.party_site_id
15716: FROM HZ_PARTY_SITE_USES site_use,
15717: HZ_PARTY_SITES site,
15718: HZ_PARTIES party
15719: WHERE site_use.party_site_use_id = p_site_use_id
15720: AND party.party_id = p_party_id
15721: AND nvl(site_use.status,'A') = 'A'
15722: AND site_use.site_use_type = 'BILL_TO'

Line 15731: HZ_PARTIES party

15727: p_party_id IN NUMBER) IS
15728: SELECT site_use.party_site_id
15729: FROM HZ_PARTY_SITE_USES site_use,
15730: HZ_PARTY_SITES site,
15731: HZ_PARTIES party
15732: WHERE site_use.party_site_use_id = p_site_use_id
15733: AND party.party_id = p_party_id
15734: AND nvl(site_use.status,'A') = 'A'
15735: AND site_use.site_use_type = 'SHIP_TO'

Line 16687: HZ_PARTIES hp

16683: SELECT header_id,
16684: open_flag
16685: FROM OE_ORDER_HEADERS_ALL ooha,
16686: HZ_CUST_ACCOUNTS acct,
16687: HZ_PARTIES hp
16688: WHERE ooha.sold_to_org_id = acct.cust_account_id
16689: AND acct.party_id = hp.party_id
16690: AND ooha.header_id = p_order_header_id
16691: AND ooha.org_id = p_org_id;