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

Line 1015: hz_parties contact_person,

1011: CURSOR c_GetShipperPartyRelId(p_locId NUMBER, p_delpartyId NUMBER) IS
1012: SELECT hrel.party_id, contact_person.party_id, email_record.email_address, hrel.end_date
1013: FROM hz_party_sites hps,
1014: hz_party_site_uses hpsu,
1015: hz_parties contact_person,
1016: hz_org_contacts supplier_contact,
1017: hz_contact_points phone_record,
1018: hz_contact_points email_record,
1019: hz_relationships hrel

Line 1023: AND hrel.subject_table_name = 'HZ_PARTIES'

1019: hz_relationships hrel
1020: WHERE hps.party_site_id = hpsu.party_site_id
1021: AND hpsu.site_use_type = 'SUPPLIER_SHIP_FROM'
1022: AND hrel.subject_id = contact_person.party_id
1023: AND hrel.subject_table_name = 'HZ_PARTIES'
1024: AND hrel.subject_type = 'PERSON'
1025: AND hrel.object_id = hps.party_id
1026: AND hrel.object_table_name = 'HZ_PARTIES'
1027: AND hrel.object_type = 'ORGANIZATION'

Line 1026: AND hrel.object_table_name = 'HZ_PARTIES'

1022: AND hrel.subject_id = contact_person.party_id
1023: AND hrel.subject_table_name = 'HZ_PARTIES'
1024: AND hrel.subject_type = 'PERSON'
1025: AND hrel.object_id = hps.party_id
1026: AND hrel.object_table_name = 'HZ_PARTIES'
1027: AND hrel.object_type = 'ORGANIZATION'
1028: AND hrel.relationship_code = 'CONTACT_OF'
1029: AND hrel.directional_flag = 'F'
1030: AND supplier_contact.party_relationship_id =hrel.relationship_id

Line 1032: AND phone_record.owner_table_name(+) = 'HZ_PARTIES'

1028: AND hrel.relationship_code = 'CONTACT_OF'
1029: AND hrel.directional_flag = 'F'
1030: AND supplier_contact.party_relationship_id =hrel.relationship_id
1031: AND supplier_contact.party_site_id = hps.party_site_id
1032: AND phone_record.owner_table_name(+) = 'HZ_PARTIES'
1033: AND phone_record.owner_table_id(+) = hrel.party_id
1034: AND phone_record.contact_point_type(+) = 'PHONE'
1035: AND email_record.owner_table_name = 'HZ_PARTIES'
1036: AND email_record.owner_table_id = hrel.party_id

Line 1035: AND email_record.owner_table_name = 'HZ_PARTIES'

1031: AND supplier_contact.party_site_id = hps.party_site_id
1032: AND phone_record.owner_table_name(+) = 'HZ_PARTIES'
1033: AND phone_record.owner_table_id(+) = hrel.party_id
1034: AND phone_record.contact_point_type(+) = 'PHONE'
1035: AND email_record.owner_table_name = 'HZ_PARTIES'
1036: AND email_record.owner_table_id = hrel.party_id
1037: AND email_record.contact_point_type = 'EMAIL'
1038: AND hps.location_id = p_locId
1039: AND hps.party_id = p_delpartyId;

Line 1055: AND hz.subject_table_name = 'HZ_PARTIES'

1051: AND hz.subject_type = 'ORGANIZATION'
1052: AND hz.object_type = 'PERSON'
1053: AND hz.relationship_type = 'POS_EMPLOYMENT'
1054: AND hz.relationship_code = 'EMPLOYER_OF'
1055: AND hz.subject_table_name = 'HZ_PARTIES'
1056: AND hz.object_table_name = 'HZ_PARTIES'
1057: AND hz.status = 'A'
1058: AND hz.start_date <= sysdate
1059: AND hz.end_date >= sysdate;

Line 1056: AND hz.object_table_name = 'HZ_PARTIES'

1052: AND hz.object_type = 'PERSON'
1053: AND hz.relationship_type = 'POS_EMPLOYMENT'
1054: AND hz.relationship_code = 'EMPLOYER_OF'
1055: AND hz.subject_table_name = 'HZ_PARTIES'
1056: AND hz.object_table_name = 'HZ_PARTIES'
1057: AND hz.status = 'A'
1058: AND hz.start_date <= sysdate
1059: AND hz.end_date >= sysdate;
1060: --

Line 1619: hz_parties party_rel,

1615: hz_party_sites hps,
1616: hz_org_contacts hoc,
1617: hz_contact_points hcp,
1618: hz_contact_points hcp2,
1619: hz_parties party_rel,
1620: wsh_org_carrier_sites wocs
1621: WHERE wcs.carrier_site_id = hps.party_site_id
1622: AND hps.party_id = rel.object_id
1623: AND hps.party_site_id = hoc.party_site_id

Line 1628: AND hcp.owner_table_name = 'HZ_PARTIES'

1624: AND hoc.party_relationship_id = rel.relationship_id
1625: AND party_rel.party_id = rel.subject_id
1626: AND hcp.owner_table_id = rel.party_id
1627: AND hcp.contact_point_type = 'EMAIL'
1628: AND hcp.owner_table_name = 'HZ_PARTIES'
1629: AND wcs.carrier_id= p_carrier_id
1630: AND hoc.decision_maker_flag = 'Y'
1631: AND hcp2.owner_table_id(+) = rel.party_id
1632: AND hcp2.contact_point_type(+) = 'PHONE'

Line 1633: AND hcp2.owner_table_name(+) = 'HZ_PARTIES'

1629: AND wcs.carrier_id= p_carrier_id
1630: AND hoc.decision_maker_flag = 'Y'
1631: AND hcp2.owner_table_id(+) = rel.party_id
1632: AND hcp2.contact_point_type(+) = 'PHONE'
1633: AND hcp2.owner_table_name(+) = 'HZ_PARTIES'
1634: AND wcs.carrier_site_id = wocs.carrier_site_id
1635: AND wocs.organization_id = p_organization_id;
1636:
1637: --Cursor to get carrier,Mode of transport,Service level and load tender status for a trip.

Line 1647: FROM wsh_carriers, hz_parties

1643:
1644: --Cursor to get carrier name.
1645: CURSOR get_carrier_name(p_carrier_id NUMBER) IS
1646: SELECT party_name
1647: FROM wsh_carriers, hz_parties
1648: WHERE carrier_id =party_id
1649: AND carrier_id= p_carrier_id;
1650: --
1651: