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

Line 101: FROM hz_parties hp,

97: CURSOR l_cust_cur( p_customer_id IN NUMBER )
98: IS
99: SELECT hp.party_name,
100: hca.account_number
101: FROM hz_parties hp,
102: hz_cust_accounts hca
103: WHERE hca.party_id = hp.party_id
104: AND hca.cust_account_id = p_customer_id;
105:

Line 845: HZ_PARTIES HP,

841: HZ_CUST_SITE_USES_ALL HCSU,
842: HZ_CUST_ACCT_SITES_ALL HCAS,
843: HZ_PARTY_SITES HPS,
844: HZ_CUST_ACCOUNTS HCA,
845: HZ_PARTIES HP,
846: WSH_LOCATIONS WL1
847: WHERE
848: WL1.wsh_location_id = p_loc_id AND
849: HCA.CUST_ACCOUNT_ID = p_cust_id AND --bugfix 3842898

Line 923: FROM HZ_PARTIES HP,

919: -- removed the nvl from org_id k proj
920:
921: CURSOR c_cust_info_cur(p_customer_id IN NUMBER) IS
922: SELECT HP.PARTY_NAME, HP.PARTY_NUMBER
923: FROM HZ_PARTIES HP,
924: HZ_CUST_ACCOUNTS HCA
925: WHERE HP.PARTY_ID = HCA.PARTY_ID
926: AND HCA.CUST_ACCOUNT_ID = p_customer_id;
927:

Line 1198: l_per_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

1194: l_debug_on BOOLEAN;
1195: --
1196: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.'
1197: || 'GET_NAME_NUMBER';
1198: l_per_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
1199: l_per_middle_name HZ_PARTIES.PERSON_MIDDLE_NAME%TYPE;
1200: l_per_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
1201: l_owner_table_id NUMBER;
1202:

Line 1199: l_per_middle_name HZ_PARTIES.PERSON_MIDDLE_NAME%TYPE;

1195: --
1196: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.'
1197: || 'GET_NAME_NUMBER';
1198: l_per_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
1199: l_per_middle_name HZ_PARTIES.PERSON_MIDDLE_NAME%TYPE;
1200: l_per_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
1201: l_owner_table_id NUMBER;
1202:
1203: cursor l_ship_to_site_contact_csr(p_contact_id IN NUMBER) is

Line 1200: l_per_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

1196: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.'
1197: || 'GET_NAME_NUMBER';
1198: l_per_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
1199: l_per_middle_name HZ_PARTIES.PERSON_MIDDLE_NAME%TYPE;
1200: l_per_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
1201: l_owner_table_id NUMBER;
1202:
1203: cursor l_ship_to_site_contact_csr(p_contact_id IN NUMBER) is
1204: SELECT PER_CONTACT.PERSON_FIRST_NAME,

Line 1213: HZ_PARTIES PER_CONTACT

1209: from HZ_CUST_ACCOUNT_ROLES HCAR,
1210: HZ_RELATIONSHIPS HREL,
1211: HZ_ORG_CONTACTS HOC,
1212: HZ_CONTACT_POINTS PHONE_CONTACT,
1213: HZ_PARTIES PER_CONTACT
1214: WHERE HCAR.CUST_ACCOUNT_ROLE_ID = p_contact_id
1215: AND HREL.PARTY_ID = HCAR.PARTY_ID
1216: AND HCAR.ROLE_TYPE = 'CONTACT'
1217: AND HREL.RELATIONSHIP_ID = HOC.PARTY_RELATIONSHIP_ID

Line 1218: AND HREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1214: WHERE HCAR.CUST_ACCOUNT_ROLE_ID = p_contact_id
1215: AND HREL.PARTY_ID = HCAR.PARTY_ID
1216: AND HCAR.ROLE_TYPE = 'CONTACT'
1217: AND HREL.RELATIONSHIP_ID = HOC.PARTY_RELATIONSHIP_ID
1218: AND HREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1219: AND HREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1220: AND HREL.SUBJECT_TYPE = 'PERSON'
1221: AND HREL.DIRECTIONAL_FLAG = 'F'
1222: AND HREL.SUBJECT_ID = PER_CONTACT.PARTY_ID

Line 1219: AND HREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1215: AND HREL.PARTY_ID = HCAR.PARTY_ID
1216: AND HCAR.ROLE_TYPE = 'CONTACT'
1217: AND HREL.RELATIONSHIP_ID = HOC.PARTY_RELATIONSHIP_ID
1218: AND HREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1219: AND HREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1220: AND HREL.SUBJECT_TYPE = 'PERSON'
1221: AND HREL.DIRECTIONAL_FLAG = 'F'
1222: AND HREL.SUBJECT_ID = PER_CONTACT.PARTY_ID
1223: AND PHONE_CONTACT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

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

1219: AND HREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1220: AND HREL.SUBJECT_TYPE = 'PERSON'
1221: AND HREL.DIRECTIONAL_FLAG = 'F'
1222: AND HREL.SUBJECT_ID = PER_CONTACT.PARTY_ID
1223: AND PHONE_CONTACT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
1224: AND PHONE_CONTACT.OWNER_TABLE_ID(+) = HREL.PARTY_ID
1225: AND PHONE_CONTACT.CONTACT_POINT_TYPE(+) = 'PHONE'
1226: AND PHONE_CONTACT.PHONE_LINE_TYPE(+) = 'GEN'
1227: AND PHONE_CONTACT.PRIMARY_FLAG(+) = 'Y';

Line 1232: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'

1228:
1229: cursor l_ship_to_site_ph_csr(p_owner_tbl_id IN NUMBER) is
1230: SELECT RAW_PHONE_NUMBER
1231: FROM HZ_CONTACT_POINTS
1232: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
1233: AND OWNER_TABLE_ID = p_owner_tbl_id
1234: AND CONTACT_POINT_TYPE = 'PHONE'
1235: AND PHONE_LINE_TYPE = 'GEN';
1236:

Line 1441: FROM hz_parties hp,

1437:
1438: -- Distributed - TPW Changes
1439: CURSOR c_cust_name_cur( c_customer_id IN NUMBER ) IS
1440: SELECT hp.party_name
1441: FROM hz_parties hp,
1442: hz_cust_accounts hca
1443: WHERE hca.party_id = hp.party_id
1444: AND hca.cust_account_id = c_customer_id;
1445:

Line 2722: l_per_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;

2718: l_debug_on BOOLEAN;
2719: --
2720: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.'
2721: || 'GET_NAME_NUMBER';
2722: l_per_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
2723: l_per_middle_name HZ_PARTIES.PERSON_MIDDLE_NAME%TYPE;
2724: l_per_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
2725: l_owner_table_id NUMBER;
2726:

Line 2723: l_per_middle_name HZ_PARTIES.PERSON_MIDDLE_NAME%TYPE;

2719: --
2720: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.'
2721: || 'GET_NAME_NUMBER';
2722: l_per_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
2723: l_per_middle_name HZ_PARTIES.PERSON_MIDDLE_NAME%TYPE;
2724: l_per_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
2725: l_owner_table_id NUMBER;
2726:
2727: cursor l_ship_to_site_contact_csr(p_contact_id IN NUMBER) is

Line 2724: l_per_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;

2720: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.'
2721: || 'GET_NAME_NUMBER';
2722: l_per_first_name HZ_PARTIES.PERSON_FIRST_NAME%TYPE;
2723: l_per_middle_name HZ_PARTIES.PERSON_MIDDLE_NAME%TYPE;
2724: l_per_last_name HZ_PARTIES.PERSON_LAST_NAME%TYPE;
2725: l_owner_table_id NUMBER;
2726:
2727: cursor l_ship_to_site_contact_csr(p_contact_id IN NUMBER) is
2728: SELECT PER_CONTACT.PERSON_FIRST_NAME,

Line 2737: HZ_PARTIES PER_CONTACT

2733: from HZ_CUST_ACCOUNT_ROLES HCAR,
2734: HZ_RELATIONSHIPS HREL,
2735: HZ_ORG_CONTACTS HOC,
2736: HZ_CONTACT_POINTS PHONE_CONTACT,
2737: HZ_PARTIES PER_CONTACT
2738: WHERE HCAR.CUST_ACCOUNT_ROLE_ID = p_contact_id
2739: AND HREL.PARTY_ID = HCAR.PARTY_ID
2740: AND HCAR.ROLE_TYPE = 'CONTACT'
2741: AND HREL.RELATIONSHIP_ID = HOC.PARTY_RELATIONSHIP_ID

Line 2742: AND HREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

2738: WHERE HCAR.CUST_ACCOUNT_ROLE_ID = p_contact_id
2739: AND HREL.PARTY_ID = HCAR.PARTY_ID
2740: AND HCAR.ROLE_TYPE = 'CONTACT'
2741: AND HREL.RELATIONSHIP_ID = HOC.PARTY_RELATIONSHIP_ID
2742: AND HREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2743: AND HREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2744: AND HREL.SUBJECT_TYPE = 'PERSON'
2745: AND HREL.DIRECTIONAL_FLAG = 'F'
2746: AND HREL.SUBJECT_ID = PER_CONTACT.PARTY_ID

Line 2743: AND HREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

2739: AND HREL.PARTY_ID = HCAR.PARTY_ID
2740: AND HCAR.ROLE_TYPE = 'CONTACT'
2741: AND HREL.RELATIONSHIP_ID = HOC.PARTY_RELATIONSHIP_ID
2742: AND HREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
2743: AND HREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2744: AND HREL.SUBJECT_TYPE = 'PERSON'
2745: AND HREL.DIRECTIONAL_FLAG = 'F'
2746: AND HREL.SUBJECT_ID = PER_CONTACT.PARTY_ID
2747: AND PHONE_CONTACT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

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

2743: AND HREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
2744: AND HREL.SUBJECT_TYPE = 'PERSON'
2745: AND HREL.DIRECTIONAL_FLAG = 'F'
2746: AND HREL.SUBJECT_ID = PER_CONTACT.PARTY_ID
2747: AND PHONE_CONTACT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
2748: AND PHONE_CONTACT.OWNER_TABLE_ID(+) = HREL.PARTY_ID
2749: AND PHONE_CONTACT.CONTACT_POINT_TYPE(+) = 'PHONE'
2750: AND PHONE_CONTACT.PHONE_LINE_TYPE(+) = 'GEN'
2751: AND PHONE_CONTACT.PRIMARY_FLAG(+) = 'Y';

Line 2756: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'

2752:
2753: cursor l_ship_to_site_ph_csr(p_owner_tbl_id IN NUMBER) is
2754: SELECT RAW_PHONE_NUMBER
2755: FROM HZ_CONTACT_POINTS
2756: WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
2757: AND OWNER_TABLE_ID = p_owner_tbl_id
2758: AND CONTACT_POINT_TYPE = 'PHONE'
2759: AND PHONE_LINE_TYPE = 'GEN';
2760:

Line 2928: FROM HZ_PARTIES HP,

2924:
2925: CURSOR c_cust_name(c_customer_id IN NUMBER)
2926: IS
2927: SELECT HP.PARTY_NAME
2928: FROM HZ_PARTIES HP,
2929: HZ_CUST_ACCOUNTS HCA
2930: WHERE HP.PARTY_ID = HCA.PARTY_ID
2931: AND HCA.CUST_ACCOUNT_ID = c_customer_id;
2932: