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_OTM_REF_DATA_GEN_PKG dependencies on HZ_PARTIES

Line 117: HZ_PARTIES HP,

113:
114: cursor l_stop_dd_cust_csr(p_stop_id IN NUMBER) is
115: SELECT HCA.CUST_ACCOUNT_ID
116: FROM HZ_CUST_ACCOUNTS HCA,
117: HZ_PARTIES HP,
118: HZ_PARTY_SITES HPS,
119: WSH_LOCATIONS WL,
120: WSH_NEW_DELIVERIES WND,
121: WSH_DELIVERY_LEGS WDL,

Line 142: HZ_PARTIES HP,

138:
139: cursor l_stop_cust_csr(p_stop_id IN NUMBER) is
140: SELECT HCA.CUST_ACCOUNT_ID
141: FROM HZ_CUST_ACCOUNTS HCA,
142: HZ_PARTIES HP,
143: HZ_PARTY_SITES HPS,
144: WSH_LOCATIONS WL,
145: WSH_TRIP_STOPS WTS
146: WHERE WTS.STOP_ID = p_stop_id

Line 1451: HZ_PARTIES HP,

1447: FROM HZ_LOCATIONS HZL,
1448: WSH_LOCATIONS WL,
1449: FND_TERRITORIES FNDTR,
1450: WSH_OTM_LOCATIONS_GTMP WLT,
1451: HZ_PARTIES HP,
1452: HZ_CUST_ACCOUNTS HCA
1453: WHERE HZL.LOCATION_ID = WL.SOURCE_LOCATION_ID
1454: AND WL.LOCATION_SOURCE_CODE = 'HZ'
1455: AND FNDTR.TERRITORY_CODE (+) = HZL.COUNTRY

Line 1489: HZ_PARTIES PER_CONTACT,

1485: FROM HZ_CUST_ACCOUNT_ROLES HCAR,
1486: HZ_RELATIONSHIPS HREL,
1487: HZ_ORG_CONTACTS HOC,
1488: HZ_CONTACT_POINTS PHONE_CONTACT,
1489: HZ_PARTIES PER_CONTACT,
1490: WSH_OTM_LOC_CONTACTS_GTMP WLCT
1491: WHERE HREL.PARTY_ID = HCAR.PARTY_ID
1492: AND HCAR.ROLE_TYPE = 'CONTACT'
1493: AND HREL.RELATIONSHIP_ID = HOC.PARTY_RELATIONSHIP_ID

Line 1494: AND HREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1490: WSH_OTM_LOC_CONTACTS_GTMP WLCT
1491: WHERE HREL.PARTY_ID = HCAR.PARTY_ID
1492: AND HCAR.ROLE_TYPE = 'CONTACT'
1493: AND HREL.RELATIONSHIP_ID = HOC.PARTY_RELATIONSHIP_ID
1494: AND HREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1495: AND HREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1496: AND HREL.SUBJECT_TYPE = 'PERSON'
1497: AND HREL.DIRECTIONAL_FLAG = 'F'
1498: AND HREL.SUBJECT_ID = PER_CONTACT.PARTY_ID

Line 1495: AND HREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1491: WHERE HREL.PARTY_ID = HCAR.PARTY_ID
1492: AND HCAR.ROLE_TYPE = 'CONTACT'
1493: AND HREL.RELATIONSHIP_ID = HOC.PARTY_RELATIONSHIP_ID
1494: AND HREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1495: AND HREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1496: AND HREL.SUBJECT_TYPE = 'PERSON'
1497: AND HREL.DIRECTIONAL_FLAG = 'F'
1498: AND HREL.SUBJECT_ID = PER_CONTACT.PARTY_ID
1499: AND PHONE_CONTACT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

Line 1499: AND PHONE_CONTACT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

1495: AND HREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1496: AND HREL.SUBJECT_TYPE = 'PERSON'
1497: AND HREL.DIRECTIONAL_FLAG = 'F'
1498: AND HREL.SUBJECT_ID = PER_CONTACT.PARTY_ID
1499: AND PHONE_CONTACT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
1500: AND PHONE_CONTACT.OWNER_TABLE_ID(+) = HREL.PARTY_ID
1501: AND PHONE_CONTACT.CONTACT_POINT_TYPE(+) = 'PHONE'
1502: AND PHONE_CONTACT.PHONE_LINE_TYPE(+) = 'GEN'
1503: AND PHONE_CONTACT.PRIMARY_FLAG(+) = 'Y'

Line 1544: HZ_PARTIES HP,

1540: WSH_OTM_LOCATIONS_GTMP wlt,
1541: WSH_CARRIERS WCV,
1542: WSH_CARRIER_SITES WCS,
1543: HZ_PARTY_SITES HPS,
1544: HZ_PARTIES HP,
1545: WSH_LOCATIONS WSL
1546: WHERE WCV.CARRIER_ID = HPS.PARTY_ID
1547: AND HPS.LOCATION_ID = HZL.LOCATION_ID
1548: AND WSL.SOURCE_LOCATION_ID = HZL.LOCATION_ID