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

Line 632: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;

628: RAISE;
629: END;
630: END CF_OE_LINE_ID1FORMULA;
631: FUNCTION CF_BILL_TO_CONTACT1FORMULA RETURN CHAR IS
632: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;
633: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
634: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
635: L_LOOKUP_TYPE VARCHAR2(20);
636: BEGIN

Line 633: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;

629: END;
630: END CF_OE_LINE_ID1FORMULA;
631: FUNCTION CF_BILL_TO_CONTACT1FORMULA RETURN CHAR IS
632: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;
633: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
634: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
635: L_LOOKUP_TYPE VARCHAR2(20);
636: BEGIN
637: /*SRW.REFERENCE(CP_BILL_TO_CONTACT_ID)*/NULL;

Line 634: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;

630: END CF_OE_LINE_ID1FORMULA;
631: FUNCTION CF_BILL_TO_CONTACT1FORMULA RETURN CHAR IS
632: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;
633: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
634: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
635: L_LOOKUP_TYPE VARCHAR2(20);
636: BEGIN
637: /*SRW.REFERENCE(CP_BILL_TO_CONTACT_ID)*/NULL;
638: IF (CP_BILL_TO_CONTACT_ID IS NOT NULL) THEN

Line 646: HZ_PARTIES PARTY,

642: ,PARTY.PERSON_TITLE) TITLE
643: INTO CONTACT_NAME,L_PERSON_TITLE
644: FROM
645: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
646: HZ_PARTIES PARTY,
647: HZ_RELATIONSHIPS REL,
648: HZ_ORG_CONTACTS ORG_CONT,
649: HZ_PARTIES REL_PARTY
650: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = CP_BILL_TO_CONTACT_ID

Line 649: HZ_PARTIES REL_PARTY

645: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
646: HZ_PARTIES PARTY,
647: HZ_RELATIONSHIPS REL,
648: HZ_ORG_CONTACTS ORG_CONT,
649: HZ_PARTIES REL_PARTY
650: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = CP_BILL_TO_CONTACT_ID
651: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
652: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
653: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 653: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

649: HZ_PARTIES REL_PARTY
650: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = CP_BILL_TO_CONTACT_ID
651: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
652: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
653: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
654: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
655: AND REL.DIRECTIONAL_FLAG = 'F'
656: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
657: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 654: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

650: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = CP_BILL_TO_CONTACT_ID
651: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
652: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
653: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
654: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
655: AND REL.DIRECTIONAL_FLAG = 'F'
656: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
657: AND REL.SUBJECT_ID = PARTY.PARTY_ID
658: AND REL.PARTY_ID = REL_PARTY.PARTY_ID;

Line 687: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;

683: WHEN OTHERS THEN
684: RAISE;
685: END CF_BILL_TO_CONTACT1FORMULA;
686: FUNCTION CF_SHIP_TO_CONTACT1FORMULA RETURN CHAR IS
687: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;
688: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
689: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
690: L_LOOKUP_TYPE VARCHAR2(20);
691: BEGIN

Line 688: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;

684: RAISE;
685: END CF_BILL_TO_CONTACT1FORMULA;
686: FUNCTION CF_SHIP_TO_CONTACT1FORMULA RETURN CHAR IS
687: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;
688: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
689: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
690: L_LOOKUP_TYPE VARCHAR2(20);
691: BEGIN
692: /*SRW.REFERENCE(CP_SHIP_TO_CONTACT_ID)*/NULL;

Line 689: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;

685: END CF_BILL_TO_CONTACT1FORMULA;
686: FUNCTION CF_SHIP_TO_CONTACT1FORMULA RETURN CHAR IS
687: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;
688: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
689: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
690: L_LOOKUP_TYPE VARCHAR2(20);
691: BEGIN
692: /*SRW.REFERENCE(CP_SHIP_TO_CONTACT_ID)*/NULL;
693: IF (CP_SHIP_TO_CONTACT_ID IS NOT NULL) THEN

Line 701: HZ_PARTIES PARTY,

697: ,PARTY.PERSON_TITLE) TITLE
698: INTO CONTACT_NAME,L_PERSON_TITLE
699: FROM
700: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
701: HZ_PARTIES PARTY,
702: HZ_RELATIONSHIPS REL,
703: HZ_ORG_CONTACTS ORG_CONT,
704: HZ_PARTIES REL_PARTY
705: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = CP_SHIP_TO_CONTACT_ID

Line 704: HZ_PARTIES REL_PARTY

700: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
701: HZ_PARTIES PARTY,
702: HZ_RELATIONSHIPS REL,
703: HZ_ORG_CONTACTS ORG_CONT,
704: HZ_PARTIES REL_PARTY
705: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = CP_SHIP_TO_CONTACT_ID
706: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
707: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
708: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 708: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

704: HZ_PARTIES REL_PARTY
705: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = CP_SHIP_TO_CONTACT_ID
706: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
707: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
708: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
709: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
710: AND REL.DIRECTIONAL_FLAG = 'F'
711: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
712: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 709: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

705: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = CP_SHIP_TO_CONTACT_ID
706: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
707: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
708: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
709: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
710: AND REL.DIRECTIONAL_FLAG = 'F'
711: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
712: AND REL.SUBJECT_ID = PARTY.PARTY_ID
713: AND REL.PARTY_ID = REL_PARTY.PARTY_ID;

Line 744: BILL_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;

740: END CF_SHIP_TO_CONTACT1FORMULA;
741: FUNCTION F_BILL_TO_CUST_NAME1FORMULA(F_OE_LINE_ID IN NUMBER) RETURN CHAR IS
742: BEGIN
743: DECLARE
744: BILL_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
745: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
746: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
747: L_LOOKUP_TYPE VARCHAR2(20);
748: BEGIN

Line 745: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;

741: FUNCTION F_BILL_TO_CUST_NAME1FORMULA(F_OE_LINE_ID IN NUMBER) RETURN CHAR IS
742: BEGIN
743: DECLARE
744: BILL_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
745: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
746: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
747: L_LOOKUP_TYPE VARCHAR2(20);
748: BEGIN
749: /*SRW.REFERENCE(F_OE_LINE_ID)*/NULL;

Line 746: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;

742: BEGIN
743: DECLARE
744: BILL_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
745: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
746: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
747: L_LOOKUP_TYPE VARCHAR2(20);
748: BEGIN
749: /*SRW.REFERENCE(F_OE_LINE_ID)*/NULL;
750: IF CP_SOURCE_CODE = 'OE' THEN

Line 760: HZ_PARTIES HP,

756: FROM
757: HZ_PARTY_SITES PS,
758: HZ_CUST_ACCT_SITES_ALL CA,
759: HZ_CUST_SITE_USES_ALL SU,
760: HZ_PARTIES HP,
761: OE_ORDER_LINES_ALL OLA
762: WHERE OLA.LINE_ID = F_OE_LINE_ID
763: AND SU.SITE_USE_ID = OLA.INVOICE_TO_ORG_ID
764: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID

Line 827: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;

823: END CF_LINE_TAX_CODE1FORMULA;
824: FUNCTION F_SHIP_TO_CUST_NAME1FORMULA(F_SHIP_TO_SITE_USE_ID IN NUMBER) RETURN CHAR IS
825: BEGIN
826: DECLARE
827: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
828: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
829: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
830: L_LOOKUP_TYPE VARCHAR2(20);
831: BEGIN

Line 828: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;

824: FUNCTION F_SHIP_TO_CUST_NAME1FORMULA(F_SHIP_TO_SITE_USE_ID IN NUMBER) RETURN CHAR IS
825: BEGIN
826: DECLARE
827: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
828: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
829: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
830: L_LOOKUP_TYPE VARCHAR2(20);
831: BEGIN
832: /*SRW.REFERENCE(F_SHIP_TO_SITE_USE_ID)*/NULL;

Line 829: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;

825: BEGIN
826: DECLARE
827: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
828: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
829: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
830: L_LOOKUP_TYPE VARCHAR2(20);
831: BEGIN
832: /*SRW.REFERENCE(F_SHIP_TO_SITE_USE_ID)*/NULL;
833: SELECT

Line 842: HZ_PARTIES HP

838: FROM
839: HZ_PARTY_SITES PS,
840: HZ_CUST_ACCT_SITES_ALL CA,
841: HZ_CUST_SITE_USES_ALL SU,
842: HZ_PARTIES HP
843: WHERE SU.SITE_USE_ID = F_SHIP_TO_SITE_USE_ID
844: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
845: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID
846: AND HP.PARTY_ID = PS.PARTY_ID;