APPS.WSH_WSHRDLAB_XMLP_PKG dependencies on HZ_PARTIES

Line 148: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;

144:
145: FUNCTION CF_SHIP_TO_CUST_NAMEFORMULA(C_SHIP_TO_SITE_USE_ID IN NUMBER) RETURN CHAR IS
146: BEGIN
147: DECLARE
148: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
149: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
150: L_ADDRESSEE HZ_PARTY_SITES.ADDRESSEE%TYPE;
151: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
152: L_LOOKUP_TYPE VARCHAR2(20);

Line 149: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;

145: FUNCTION CF_SHIP_TO_CUST_NAMEFORMULA(C_SHIP_TO_SITE_USE_ID IN NUMBER) RETURN CHAR IS
146: BEGIN
147: DECLARE
148: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
149: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
150: L_ADDRESSEE HZ_PARTY_SITES.ADDRESSEE%TYPE;
151: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
152: L_LOOKUP_TYPE VARCHAR2(20);
153: BEGIN

Line 151: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;

147: DECLARE
148: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
149: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
150: L_ADDRESSEE HZ_PARTY_SITES.ADDRESSEE%TYPE;
151: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
152: L_LOOKUP_TYPE VARCHAR2(20);
153: BEGIN
154: /*SRW.REFERENCE(C_SHIP_TO_SITE_USE_ID)*/NULL;
155: SELECT

Line 165: HZ_PARTIES HP

161: FROM
162: HZ_PARTY_SITES PS,
163: HZ_CUST_ACCT_SITES_ALL CA,
164: HZ_CUST_SITE_USES_ALL SU,
165: HZ_PARTIES HP
166: WHERE SU.SITE_USE_ID = C_SHIP_TO_SITE_USE_ID
167: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
168: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID
169: AND HP.PARTY_ID = PS.PARTY_ID;

Line 356: HZ_PARTIES PARTY,

352: PARTY.PERSON_LAST_NAME,
353: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID
354: FROM
355: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
356: HZ_PARTIES PARTY,
357: HZ_RELATIONSHIPS REL,
358: HZ_ORG_CONTACTS ORG_CONT,
359: HZ_CUST_ACCOUNTS ROLE_ACCT
360: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID

Line 364: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

360: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
361: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
362: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
363: AND REL.SUBJECT_ID = PARTY.PARTY_ID
364: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
365: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
366: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
367: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID ) CONTACT,
368: ( SELECT

Line 365: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

361: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
362: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
363: AND REL.SUBJECT_ID = PARTY.PARTY_ID
364: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
365: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
366: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
367: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID ) CONTACT,
368: ( SELECT
369: CONT_POINT.PHONE_LINE_TYPE PHONE_LINE_TYPE,

Line 380: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'

376: FROM
377: HZ_CONTACT_POINTS CONT_POINT,
378: HZ_CUST_ACCOUNT_ROLES CAR
379: WHERE CAR.PARTY_ID = CONT_POINT.OWNER_TABLE_ID
380: AND CONT_POINT.OWNER_TABLE_NAME = 'HZ_PARTIES'
381: AND CONT_POINT.CONTACT_POINT_TYPE not in ( 'EDI' , 'EMAIL' , 'WEB' ) ) PHONES,
382: WSH_DELIVERY_DETAILS WDD
383: WHERE WDD.DELIVERY_DETAIL_ID = P_DEL_DET_ID_3
384: AND WDD.SHIP_TO_CONTACT_ID = contact.cust_account_role_id (+)