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 319: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;

315:
316: FUNCTION F_SHIP_TO_CUST_NAMEFORMULA(SHIP_TO_SITE_USE_ID IN NUMBER,CONSIGNEE_FLAG IN VARCHAR2) RETURN CHAR IS
317: BEGIN
318: DECLARE
319: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
320: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
321: L_LOOKUP_TYPE VARCHAR2(20);
322: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
323: BEGIN

Line 320: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;

316: FUNCTION F_SHIP_TO_CUST_NAMEFORMULA(SHIP_TO_SITE_USE_ID IN NUMBER,CONSIGNEE_FLAG IN VARCHAR2) RETURN CHAR IS
317: BEGIN
318: DECLARE
319: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
320: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
321: L_LOOKUP_TYPE VARCHAR2(20);
322: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
323: BEGIN
324: /*SRW.REFERENCE(SHIP_TO_SITE_USE_ID)*/NULL;

Line 322: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;

318: DECLARE
319: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
320: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
321: L_LOOKUP_TYPE VARCHAR2(20);
322: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
323: BEGIN
324: /*SRW.REFERENCE(SHIP_TO_SITE_USE_ID)*/NULL;
325: /*SRW.REFERENCE(CONSIGNEE_FLAG)*/NULL;
326: IF nvl(CONSIGNEE_FLAG,'C') = 'V' THEN

Line 335: HZ_PARTIES HP

331: INTO SHIP_TO_CUST_NAME,L_PERSON_TITLE
332: FROM
333: HZ_PARTY_SITE_USES PSU,
334: HZ_PARTY_SITES PS,
335: HZ_PARTIES HP
336: WHERE PSU.PARTY_SITE_USE_ID = SHIP_TO_SITE_USE_ID
337: AND PSU.SITE_USE_TYPE = 'PURCHASING'
338: AND PS.PARTY_SITE_ID = PSU.PARTY_SITE_ID
339: AND HP.PARTY_ID = PS.PARTY_ID;

Line 350: HZ_PARTIES HP

346: FROM
347: HZ_PARTY_SITES PS,
348: HZ_CUST_ACCT_SITES_ALL CA,
349: HZ_CUST_SITE_USES_ALL SU,
350: HZ_PARTIES HP
351: WHERE SU.SITE_USE_ID = SHIP_TO_SITE_USE_ID
352: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
353: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID
354: AND HP.PARTY_ID = PS.PARTY_ID;

Line 385: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;

381: END;
382: END F_SHIP_TO_CUST_NAMEFORMULA;
383:
384: FUNCTION CF_CONTACT_NAMEFORMULA(SHIP_TO_CONTACT_ID IN NUMBER) RETURN CHAR IS
385: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;
386: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
387: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
388: L_LOOKUP_TYPE VARCHAR2(20);
389: BEGIN

Line 386: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;

382: END F_SHIP_TO_CUST_NAMEFORMULA;
383:
384: FUNCTION CF_CONTACT_NAMEFORMULA(SHIP_TO_CONTACT_ID IN NUMBER) RETURN CHAR IS
385: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;
386: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
387: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
388: L_LOOKUP_TYPE VARCHAR2(20);
389: BEGIN
390: /*SRW.REFERENCE(SHIP_TO_CONTACT_ID)*/NULL;

Line 387: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;

383:
384: FUNCTION CF_CONTACT_NAMEFORMULA(SHIP_TO_CONTACT_ID IN NUMBER) RETURN CHAR IS
385: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;
386: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
387: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
388: L_LOOKUP_TYPE VARCHAR2(20);
389: BEGIN
390: /*SRW.REFERENCE(SHIP_TO_CONTACT_ID)*/NULL;
391: IF (SHIP_TO_CONTACT_ID IS NOT NULL) THEN

Line 399: HZ_PARTIES PARTY,

395: ,PARTY.PERSON_TITLE) TITLE
396: INTO CONTACT_NAME,L_PERSON_TITLE
397: FROM
398: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
399: HZ_PARTIES PARTY,
400: HZ_RELATIONSHIPS REL,
401: HZ_ORG_CONTACTS ORG_CONT,
402: HZ_PARTIES REL_PARTY
403: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = SHIP_TO_CONTACT_ID

Line 402: HZ_PARTIES REL_PARTY

398: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
399: HZ_PARTIES PARTY,
400: HZ_RELATIONSHIPS REL,
401: HZ_ORG_CONTACTS ORG_CONT,
402: HZ_PARTIES REL_PARTY
403: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = SHIP_TO_CONTACT_ID
404: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
405: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
406: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 406: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

402: HZ_PARTIES REL_PARTY
403: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = SHIP_TO_CONTACT_ID
404: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
405: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
406: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
407: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
408: AND REL.DIRECTIONAL_FLAG = 'F'
409: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
410: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 407: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

403: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = SHIP_TO_CONTACT_ID
404: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
405: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
406: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
407: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
408: AND REL.DIRECTIONAL_FLAG = 'F'
409: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
410: AND REL.SUBJECT_ID = PARTY.PARTY_ID
411: AND REL.PARTY_ID = REL_PARTY.PARTY_ID;