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 633: FROM hz_parties

629: lv_exists_flag VARCHAR2(1) := 'N';
630:
631: CURSOR c_party IS
632: SELECT 'Y'
633: FROM hz_parties
634: WHERE party_id = p_party_id
635: AND nvl(status, 'A') = 'A';
636:
637: l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'is_party_valid';

Line 737: FROM hz_parties

733: --Check the party_type for the given party
734:
735: CURSOR c_party_type(p_party_id in number) IS
736: SELECT party_type
737: FROM hz_parties
738: WHERE party_id = p_party_id;
739:
740: CURSOR c_contact_org(p_party_id in number,
741: p_contact_id in number) IS

Line 744: hz_parties sub,

740: CURSOR c_contact_org(p_party_id in number,
741: p_contact_id in number) IS
742: SELECT rel.party_id
743: FROM hz_relationships party_rel,
744: hz_parties sub,
745: hz_parties rel,
746: ar_lookups ar,
747: ar_lookups relm,
748: hz_relationship_types typ,

Line 745: hz_parties rel,

741: p_contact_id in number) IS
742: SELECT rel.party_id
743: FROM hz_relationships party_rel,
744: hz_parties sub,
745: hz_parties rel,
746: ar_lookups ar,
747: ar_lookups relm,
748: hz_relationship_types typ,
749: hz_code_assignments asg

Line 769: AND party_rel.subject_table_name = 'HZ_PARTIES'

765: AND asg.class_category = 'RELATIONSHIP_TYPE_GROUP'
766: AND asg.class_code = 'PARTY_REL_GRP_CONTACTS'
767: AND typ.relationship_type = party_rel.relationship_type
768: AND party_rel.subject_type = 'PERSON'
769: AND party_rel.subject_table_name = 'HZ_PARTIES'
770: AND party_rel.object_type = 'ORGANIZATION'
771: AND party_rel.object_table_name = 'HZ_PARTIES'
772: AND party_rel.relationship_code = typ.forward_rel_code;
773:

Line 771: AND party_rel.object_table_name = 'HZ_PARTIES'

767: AND typ.relationship_type = party_rel.relationship_type
768: AND party_rel.subject_type = 'PERSON'
769: AND party_rel.subject_table_name = 'HZ_PARTIES'
770: AND party_rel.object_type = 'ORGANIZATION'
771: AND party_rel.object_table_name = 'HZ_PARTIES'
772: AND party_rel.relationship_code = typ.forward_rel_code;
773:
774: CURSOR c_contact_person(p_party_id number,p_contact_id number) IS
775: SELECT rel.party_id

Line 777: hz_parties sub,

773:
774: CURSOR c_contact_person(p_party_id number,p_contact_id number) IS
775: SELECT rel.party_id
776: FROM hz_relationships party_rel,
777: hz_parties sub,
778: hz_parties rel,
779: ar_lookups ar,
780: ar_lookups relm,
781: hz_relationship_types typ,

Line 778: hz_parties rel,

774: CURSOR c_contact_person(p_party_id number,p_contact_id number) IS
775: SELECT rel.party_id
776: FROM hz_relationships party_rel,
777: hz_parties sub,
778: hz_parties rel,
779: ar_lookups ar,
780: ar_lookups relm,
781: hz_relationship_types typ,
782: hz_code_assignments asg

Line 801: AND party_rel.subject_table_name = 'HZ_PARTIES'

797: AND asg.class_category = 'RELATIONSHIP_TYPE_GROUP'
798: AND asg.class_code = 'PARTY_REL_GRP_CONTACTS'
799: AND typ.relationship_type = party_rel.relationship_type
800: AND party_rel.subject_type = 'PERSON'
801: AND party_rel.subject_table_name = 'HZ_PARTIES'
802: AND party_rel.object_type = 'PERSON' -- added for bug # 4744186
803: AND party_rel.object_table_name = 'HZ_PARTIES'
804: AND party_rel.relationship_code = typ.forward_rel_code;
805:

Line 803: AND party_rel.object_table_name = 'HZ_PARTIES'

799: AND typ.relationship_type = party_rel.relationship_type
800: AND party_rel.subject_type = 'PERSON'
801: AND party_rel.subject_table_name = 'HZ_PARTIES'
802: AND party_rel.object_type = 'PERSON' -- added for bug # 4744186
803: AND party_rel.object_table_name = 'HZ_PARTIES'
804: AND party_rel.relationship_code = typ.forward_rel_code;
805:
806: lv_exists_flag VARCHAR2(1) := 'N';
807: lv_party_type VARCHAR2(30);

Line 887: HZ_PARTIES party

883: p_party_id IN NUMBER) IS
884: SELECT site.party_site_id
885: FROM HZ_PARTY_SITES site,
886: HZ_PARTY_SITE_USES site_use,
887: HZ_PARTIES party
888: WHERE site.party_site_id = p_party_site_id
889: AND site.party_id = p_party_id
890: AND site.party_id = party.party_id
891: AND site.party_site_id = site_use.party_site_id

Line 902: HZ_PARTIES party

898: p_party_id IN NUMBER) IS
899: SELECT site.party_site_id
900: FROM HZ_PARTY_SITES site,
901: HZ_PARTY_SITE_USES site_use,
902: HZ_PARTIES party
903: WHERE site.party_site_id = p_party_site_id
904: AND site.party_id = p_party_id
905: AND site.party_id = party.party_id
906: AND site.party_site_id = site_use.party_site_id

Line 915: HZ_PARTIES party

911: p_party_id IN NUMBER) IS
912:
913: SELECT site.party_site_id
914: FROM HZ_PARTY_SITES site,
915: HZ_PARTIES party
916: WHERE site.party_site_id = p_party_site_id
917: AND site.party_id = p_party_id
918: AND site.party_id = party.party_id
919: AND nvl(site.status, 'A') = 'A';

Line 1258: CP.OWNER_PARTY_SOURCE_TABLE = 'HZ_PARTIES' AND

1254: SELECT 'Y'
1255: FROM CSI_ITEM_INSTANCES cp,
1256: MTL_SYSTEM_ITEMS_KFV ITEMS
1257: WHERE cp.instance_id = p_instance_id AND
1258: CP.OWNER_PARTY_SOURCE_TABLE = 'HZ_PARTIES' AND
1259: cp.owner_party_id = p_party_id AND
1260: ITEMS.INVENTORY_ITEM_ID = CP.INVENTORY_ITEM_ID AND
1261: ITEMS.ORGANIZATION_ID = cs_std.get_item_valdn_orgzn_id AND
1262: exists (select 'x'

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

1262: exists (select 'x'
1263: from csi_i_parties cip
1264: where cip.party_id = p_party_id
1265: and cip.instance_id = cp.instance_id
1266: and cip.party_source_table = 'HZ_PARTIES')AND
1267: (
1268: (fnd_profile.value('CS_SR_RESTRICT_IB') = 'YES'
1269: and CP.LOCATION_TYPE_CODE IN('HZ_PARTY_SITES','HZ_LOCATIONS'))
1270: or (fnd_profile.value('CS_SR_RESTRICT_IB') <> 'YES'));

Line 13404: hz_parties hzp,

13400: inc.caller_type
13401: FROM cs_incidents_all_b inc,
13402: CS_INCIDENT_TYPES intp,
13403: CS_BUSINESS_PROCESSES bp,
13404: hz_parties hzp,
13405: hz_cust_accounts hza
13406: WHERE inc.incident_id = p_incident_id
13407: AND inc.incident_type_id = intp.incident_type_id
13408: AND intp.business_process_id = bp.business_process_id

Line 14181: HZ_PARTIES party

14177: P_PARTY_ID IN NUMBER) IS
14178: SELECT site_use.party_site_id
14179: FROM HZ_PARTY_SITE_USES site_use,
14180: HZ_PARTY_SITES site,
14181: HZ_PARTIES party
14182: WHERE site_use.party_site_use_id = p_site_use_id
14183: AND party.party_id = p_party_id
14184: AND nvl(site_use.status,'A') = 'A'
14185: AND site_use.site_use_type = 'BILL_TO'

Line 14194: HZ_PARTIES party

14190: p_party_id IN NUMBER) IS
14191: SELECT site_use.party_site_id
14192: FROM HZ_PARTY_SITE_USES site_use,
14193: HZ_PARTY_SITES site,
14194: HZ_PARTIES party
14195: WHERE site_use.party_site_use_id = p_site_use_id
14196: AND party.party_id = p_party_id
14197: AND nvl(site_use.status,'A') = 'A'
14198: AND site_use.site_use_type = 'SHIP_TO'

Line 15116: HZ_PARTIES hp

15112: SELECT header_id,
15113: open_flag
15114: FROM OE_ORDER_HEADERS_ALL ooha,
15115: HZ_CUST_ACCOUNTS acct,
15116: HZ_PARTIES hp
15117: WHERE ooha.sold_to_org_id = acct.cust_account_id
15118: AND acct.party_id = hp.party_id
15119: AND ooha.header_id = p_order_header_id
15120: AND ooha.org_id = p_org_id;