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 712: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;

708: RAISE;
709: END;
710: END CF_OE_LINE_ID1FORMULA;
711: FUNCTION CF_BILL_TO_CONTACT1FORMULA RETURN CHAR IS
712: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;
713: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
714: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
715: L_LOOKUP_TYPE VARCHAR2(20);
716: BEGIN

Line 713: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;

709: END;
710: END CF_OE_LINE_ID1FORMULA;
711: FUNCTION CF_BILL_TO_CONTACT1FORMULA RETURN CHAR IS
712: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;
713: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
714: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
715: L_LOOKUP_TYPE VARCHAR2(20);
716: BEGIN
717: /*SRW.REFERENCE(CP_BILL_TO_CONTACT_ID)*/NULL;

Line 714: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;

710: END CF_OE_LINE_ID1FORMULA;
711: FUNCTION CF_BILL_TO_CONTACT1FORMULA RETURN CHAR IS
712: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;
713: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
714: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
715: L_LOOKUP_TYPE VARCHAR2(20);
716: BEGIN
717: /*SRW.REFERENCE(CP_BILL_TO_CONTACT_ID)*/NULL;
718: IF (CP_BILL_TO_CONTACT_ID IS NOT NULL) THEN

Line 726: HZ_PARTIES PARTY,

722: ,PARTY.PERSON_TITLE) TITLE
723: INTO CONTACT_NAME,L_PERSON_TITLE
724: FROM
725: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
726: HZ_PARTIES PARTY,
727: HZ_RELATIONSHIPS REL,
728: HZ_ORG_CONTACTS ORG_CONT,
729: HZ_PARTIES REL_PARTY
730: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = CP_BILL_TO_CONTACT_ID

Line 729: HZ_PARTIES REL_PARTY

725: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
726: HZ_PARTIES PARTY,
727: HZ_RELATIONSHIPS REL,
728: HZ_ORG_CONTACTS ORG_CONT,
729: HZ_PARTIES REL_PARTY
730: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = CP_BILL_TO_CONTACT_ID
731: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
732: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
733: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 733: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

729: HZ_PARTIES REL_PARTY
730: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = CP_BILL_TO_CONTACT_ID
731: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
732: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
733: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
734: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
735: AND REL.DIRECTIONAL_FLAG = 'F'
736: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
737: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 734: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

730: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = CP_BILL_TO_CONTACT_ID
731: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
732: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
733: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
734: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
735: AND REL.DIRECTIONAL_FLAG = 'F'
736: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
737: AND REL.SUBJECT_ID = PARTY.PARTY_ID
738: AND REL.PARTY_ID = REL_PARTY.PARTY_ID;

Line 767: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;

763: WHEN OTHERS THEN
764: RAISE;
765: END CF_BILL_TO_CONTACT1FORMULA;
766: FUNCTION CF_SHIP_TO_CONTACT1FORMULA RETURN CHAR IS
767: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;
768: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
769: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
770: L_LOOKUP_TYPE VARCHAR2(20);
771: BEGIN

Line 768: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;

764: RAISE;
765: END CF_BILL_TO_CONTACT1FORMULA;
766: FUNCTION CF_SHIP_TO_CONTACT1FORMULA RETURN CHAR IS
767: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;
768: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
769: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
770: L_LOOKUP_TYPE VARCHAR2(20);
771: BEGIN
772: /*SRW.REFERENCE(CP_SHIP_TO_CONTACT_ID)*/NULL;

Line 769: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;

765: END CF_BILL_TO_CONTACT1FORMULA;
766: FUNCTION CF_SHIP_TO_CONTACT1FORMULA RETURN CHAR IS
767: CONTACT_NAME HZ_PARTIES.PARTY_NAME%TYPE;
768: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
769: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
770: L_LOOKUP_TYPE VARCHAR2(20);
771: BEGIN
772: /*SRW.REFERENCE(CP_SHIP_TO_CONTACT_ID)*/NULL;
773: IF (CP_SHIP_TO_CONTACT_ID IS NOT NULL) THEN

Line 781: HZ_PARTIES PARTY,

777: ,PARTY.PERSON_TITLE) TITLE
778: INTO CONTACT_NAME,L_PERSON_TITLE
779: FROM
780: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
781: HZ_PARTIES PARTY,
782: HZ_RELATIONSHIPS REL,
783: HZ_ORG_CONTACTS ORG_CONT,
784: HZ_PARTIES REL_PARTY
785: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = CP_SHIP_TO_CONTACT_ID

Line 784: HZ_PARTIES REL_PARTY

780: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
781: HZ_PARTIES PARTY,
782: HZ_RELATIONSHIPS REL,
783: HZ_ORG_CONTACTS ORG_CONT,
784: HZ_PARTIES REL_PARTY
785: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = CP_SHIP_TO_CONTACT_ID
786: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
787: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
788: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 788: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

784: HZ_PARTIES REL_PARTY
785: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = CP_SHIP_TO_CONTACT_ID
786: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
787: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
788: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
789: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
790: AND REL.DIRECTIONAL_FLAG = 'F'
791: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
792: AND REL.SUBJECT_ID = PARTY.PARTY_ID

Line 789: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

785: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = CP_SHIP_TO_CONTACT_ID
786: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
787: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
788: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
789: AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
790: AND REL.DIRECTIONAL_FLAG = 'F'
791: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
792: AND REL.SUBJECT_ID = PARTY.PARTY_ID
793: AND REL.PARTY_ID = REL_PARTY.PARTY_ID;

Line 824: BILL_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;

820: END CF_SHIP_TO_CONTACT1FORMULA;
821: FUNCTION F_BILL_TO_CUST_NAME1FORMULA(F_OE_LINE_ID IN NUMBER) RETURN CHAR IS
822: BEGIN
823: DECLARE
824: BILL_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
825: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
826: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
827: L_LOOKUP_TYPE VARCHAR2(20);
828: BEGIN

Line 825: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;

821: FUNCTION F_BILL_TO_CUST_NAME1FORMULA(F_OE_LINE_ID IN NUMBER) RETURN CHAR IS
822: BEGIN
823: DECLARE
824: BILL_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
825: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
826: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
827: L_LOOKUP_TYPE VARCHAR2(20);
828: BEGIN
829: /*SRW.REFERENCE(F_OE_LINE_ID)*/NULL;

Line 826: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;

822: BEGIN
823: DECLARE
824: BILL_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
825: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
826: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
827: L_LOOKUP_TYPE VARCHAR2(20);
828: BEGIN
829: /*SRW.REFERENCE(F_OE_LINE_ID)*/NULL;
830: IF CP_SOURCE_CODE = 'OE' THEN

Line 840: HZ_PARTIES HP,

836: FROM
837: HZ_PARTY_SITES PS,
838: HZ_CUST_ACCT_SITES_ALL CA,
839: HZ_CUST_SITE_USES_ALL SU,
840: HZ_PARTIES HP,
841: OE_ORDER_LINES_ALL OLA
842: WHERE OLA.LINE_ID = F_OE_LINE_ID
843: AND SU.SITE_USE_ID = OLA.INVOICE_TO_ORG_ID
844: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID

Line 878: HZ_PARTIES HP

874: INTO BILL_TO_CUST_NAME,L_PERSON_TITLE
875: FROM
876: WSH_DELIVERY_DETAILS WDD,
877: PO_VENDORS PV,
878: HZ_PARTIES HP
879: WHERE WDD.SOURCE_LINE_ID = F_OE_LINE_ID
880: AND WDD.SOURCE_CODE = 'RTV'
881: AND WDD.CUSTOMER_ID = PV.VENDOR_ID
882: AND PV.PARTY_ID = HP.PARTY_ID

Line 941: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;

937: END CF_LINE_TAX_CODE1FORMULA;
938: FUNCTION F_SHIP_TO_CUST_NAME1FORMULA(F_DEL_DETAIL_ID IN NUMBER) RETURN CHAR IS
939: BEGIN
940: DECLARE
941: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
942: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
943: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
944: L_LOOKUP_TYPE VARCHAR2(20);
945: SHP_TO_SITE_USE_ID NUMBER;

Line 942: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;

938: FUNCTION F_SHIP_TO_CUST_NAME1FORMULA(F_DEL_DETAIL_ID IN NUMBER) RETURN CHAR IS
939: BEGIN
940: DECLARE
941: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
942: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
943: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
944: L_LOOKUP_TYPE VARCHAR2(20);
945: SHP_TO_SITE_USE_ID NUMBER;
946: CONS_FLAG VARCHAR2(1);

Line 943: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;

939: BEGIN
940: DECLARE
941: SHIP_TO_CUST_NAME HZ_PARTIES.PARTY_NAME%TYPE;
942: L_PERSON_TITLE HZ_PARTIES.PERSON_TITLE%TYPE;
943: L_PERSON_TITLE_UP HZ_PARTIES.PERSON_TITLE%TYPE;
944: L_LOOKUP_TYPE VARCHAR2(20);
945: SHP_TO_SITE_USE_ID NUMBER;
946: CONS_FLAG VARCHAR2(1);
947: BEGIN

Line 969: HZ_PARTIES HP

965: INTO SHIP_TO_CUST_NAME,L_PERSON_TITLE
966: FROM
967: HZ_PARTY_SITE_USES PSU,
968: HZ_PARTY_SITES PS,
969: HZ_PARTIES HP
970: WHERE PSU.PARTY_SITE_USE_ID = SHP_TO_SITE_USE_ID
971: AND PSU.SITE_USE_TYPE = 'PURCHASING'
972: AND PS.PARTY_SITE_ID = PSU.PARTY_SITE_ID
973: AND HP.PARTY_ID = PS.PARTY_ID;

Line 985: HZ_PARTIES HP

981: FROM
982: HZ_PARTY_SITES PS,
983: HZ_CUST_ACCT_SITES_ALL CA,
984: HZ_CUST_SITE_USES_ALL SU,
985: HZ_PARTIES HP
986: WHERE SU.SITE_USE_ID = SHP_TO_SITE_USE_ID --RTV changes
987: AND SU.CUST_ACCT_SITE_ID = CA.CUST_ACCT_SITE_ID
988: AND CA.PARTY_SITE_ID = PS.PARTY_SITE_ID
989: AND HP.PARTY_ID = PS.PARTY_ID;