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

Line 305: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;

301:
302: FUNCTION F_SHIP_TO_CUST_NAMEFORMULA(SHIP_TO_SITE_USE_ID IN NUMBER) RETURN CHAR IS
303: BEGIN
304: DECLARE
305: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
306: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
307: L_LOOKUP_TYPE VARCHAR2(20);
308: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
309: BEGIN

Line 306: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;

302: FUNCTION F_SHIP_TO_CUST_NAMEFORMULA(SHIP_TO_SITE_USE_ID IN NUMBER) RETURN CHAR IS
303: BEGIN
304: DECLARE
305: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
306: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
307: L_LOOKUP_TYPE VARCHAR2(20);
308: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
309: BEGIN
310: /*SRW.REFERENCE(SHIP_TO_SITE_USE_ID)*/NULL;

Line 308: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;

304: DECLARE
305: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
306: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
307: L_LOOKUP_TYPE VARCHAR2(20);
308: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
309: BEGIN
310: /*SRW.REFERENCE(SHIP_TO_SITE_USE_ID)*/NULL;
311: SELECT
312: HP.PARTY_NAME,

Line 320: HZ_PARTIES HP

316: FROM
317: HZ_PARTY_SITES PS,
318: HZ_CUST_ACCT_SITES_ALL CA,
319: HZ_CUST_SITE_USES_ALL SU,
320: HZ_PARTIES HP
321: WHERE SU.SITE_USE_ID = SHIP_TO_SITE_USE_ID
322: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
323: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID
324: AND HP.PARTY_ID = PS.PARTY_ID;

Line 354: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;

350: END;
351: END F_SHIP_TO_CUST_NAMEFORMULA;
352:
353: FUNCTION CF_CONTACT_NAMEFORMULA(SHIP_TO_CONTACT_ID IN NUMBER) RETURN CHAR IS
354: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;
355: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
356: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
357: L_LOOKUP_TYPE VARCHAR2(20);
358: BEGIN

Line 355: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;

351: END F_SHIP_TO_CUST_NAMEFORMULA;
352:
353: FUNCTION CF_CONTACT_NAMEFORMULA(SHIP_TO_CONTACT_ID IN NUMBER) RETURN CHAR IS
354: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;
355: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
356: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
357: L_LOOKUP_TYPE VARCHAR2(20);
358: BEGIN
359: /*SRW.REFERENCE(SHIP_TO_CONTACT_ID)*/NULL;

Line 356: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;

352:
353: FUNCTION CF_CONTACT_NAMEFORMULA(SHIP_TO_CONTACT_ID IN NUMBER) RETURN CHAR IS
354: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;
355: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
356: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
357: L_LOOKUP_TYPE VARCHAR2(20);
358: BEGIN
359: /*SRW.REFERENCE(SHIP_TO_CONTACT_ID)*/NULL;
360: IF (SHIP_TO_CONTACT_ID IS NOT NULL) THEN

Line 368: HZ_PARTIES PARTY,

364: ,PARTY.PERSON_TITLE) TITLE
365: INTO CONTACT_NAME,L_PERSON_TITLE
366: FROM
367: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
368: HZ_PARTIES PARTY,
369: HZ_RELATIONSHIPS REL,
370: HZ_ORG_CONTACTS ORG_CONT,
371: HZ_PARTIES REL_PARTY
372: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = SHIP_TO_CONTACT_ID

Line 371: HZ_PARTIES REL_PARTY

367: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
368: HZ_PARTIES PARTY,
369: HZ_RELATIONSHIPS REL,
370: HZ_ORG_CONTACTS ORG_CONT,
371: HZ_PARTIES REL_PARTY
372: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = SHIP_TO_CONTACT_ID
373: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
374: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
375: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 375: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

371: HZ_PARTIES REL_PARTY
372: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = SHIP_TO_CONTACT_ID
373: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
374: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
375: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
376: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
377: AND REL.DIRECTIONAL_FLAG = 'F'
378: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
379: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 376: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

372: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = SHIP_TO_CONTACT_ID
373: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
374: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
375: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
376: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
377: AND REL.DIRECTIONAL_FLAG = 'F'
378: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
379: AND REL.SUBJECT_ID = PARTY.PARTY_ID
380: AND REL.PARTY_ID = REL_PARTY.PARTY_ID;