APPS.WSH_WSHRDLAB_XMLP_PKG dependencies on HZ_PARTIES

Line 155: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;

151:
152: FUNCTION CF_SHIP_TO_CUST_NAMEFORMULA(C_SHIP_TO_SITE_USE_ID IN NUMBER) RETURN CHAR IS
153: BEGIN
154: DECLARE
155: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
156: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
157: L_ADDRESSEE HZ_PARTY_SITES.ADDRESSEE%TYPE;
158: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
159: L_LOOKUP_TYPE VARCHAR2(20);

Line 156: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;

152: FUNCTION CF_SHIP_TO_CUST_NAMEFORMULA(C_SHIP_TO_SITE_USE_ID IN NUMBER) RETURN CHAR IS
153: BEGIN
154: DECLARE
155: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
156: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
157: L_ADDRESSEE HZ_PARTY_SITES.ADDRESSEE%TYPE;
158: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
159: L_LOOKUP_TYPE VARCHAR2(20);
160: BEGIN

Line 158: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;

154: DECLARE
155: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
156: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
157: L_ADDRESSEE HZ_PARTY_SITES.ADDRESSEE%TYPE;
158: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
159: L_LOOKUP_TYPE VARCHAR2(20);
160: BEGIN
161: /*SRW.REFERENCE(C_SHIP_TO_SITE_USE_ID)*/NULL;
162: SELECT

Line 172: HZ_PARTIES HP

168: FROM
169: HZ_PARTY_SITES PS,
170: HZ_CUST_ACCT_SITES_ALL CA,
171: HZ_CUST_SITE_USES_ALL SU,
172: HZ_PARTIES HP
173: WHERE SU.SITE_USE_ID = C_SHIP_TO_SITE_USE_ID
174: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
175: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID
176: AND HP.PARTY_ID = PS.PARTY_ID;

Line 363: HZ_PARTIES PARTY,

359: PARTY.PERSON_LAST_NAME,
360: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID
361: FROM
362: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
363: HZ_PARTIES PARTY,
364: HZ_RELATIONSHIPS REL,
365: HZ_ORG_CONTACTS ORG_CONT,
366: HZ_CUST_ACCOUNTS ROLE_ACCT
367: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID

Line 371: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

367: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
368: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
369: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
370: AND REL.SUBJECT_ID = PARTY.PARTY_ID
371: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
372: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
373: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
374: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID ) CONTACT,
375: ( SELECT

Line 372: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

368: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
369: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
370: AND REL.SUBJECT_ID = PARTY.PARTY_ID
371: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
372: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
373: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
374: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID ) CONTACT,
375: ( SELECT
376: CONT_POINT.PHONE_LINE_TYPE PHONE_LINE_TYPE,

Line 387: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'

383: FROM
384: HZ_CONTACT_POINTS CONT_POINT,
385: HZ_CUST_ACCOUNT_ROLES CAR
386: WHERE CAR.PARTY_ID = CONT_POINT.OWNER_TABLE_ID
387: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'
388: AND CONT_POINT.CONTACT_POINT_TYPE not in ( 'EDI' , 'EMAIL' , 'WEB' ) ) PHONES,
389: WSH_DELIVERY_DETAILS WDD
390: WHERE WDD.DELIVERY_DETAIL_ID = P_DEL_DET_ID_3
391: AND WDD.SHIP_TO_CONTACT_ID = contact.cust_account_role_id (+)