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.OKS_IMPORT_VALIDATE dependencies on HZ_PARTIES

Line 873: ,HZ_PARTIES HPCUSTI

869: ,HDI.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
870: ,trunc(HDI.CURRENCY_CONVERSION_DATE) CURRENCY_CONVERSION_DATE
871: ,HDI.CONTRACT_CURRENCY_CODE CONTRACT_CURRENCY_CODE
872: FROM OKS_HEADERS_INTERFACE HDI
873: ,HZ_PARTIES HPCUSTI
874: ,HZ_PARTIES HPCUSTN
875: ,HZ_PARTIES HPCUSTNUM
876: ,HZ_PARTIES HPTPI
877: ,HZ_PARTIES HPTPN

Line 874: ,HZ_PARTIES HPCUSTN

870: ,trunc(HDI.CURRENCY_CONVERSION_DATE) CURRENCY_CONVERSION_DATE
871: ,HDI.CONTRACT_CURRENCY_CODE CONTRACT_CURRENCY_CODE
872: FROM OKS_HEADERS_INTERFACE HDI
873: ,HZ_PARTIES HPCUSTI
874: ,HZ_PARTIES HPCUSTN
875: ,HZ_PARTIES HPCUSTNUM
876: ,HZ_PARTIES HPTPI
877: ,HZ_PARTIES HPTPN
878: ,HZ_PARTIES HPTPNUM

Line 875: ,HZ_PARTIES HPCUSTNUM

871: ,HDI.CONTRACT_CURRENCY_CODE CONTRACT_CURRENCY_CODE
872: FROM OKS_HEADERS_INTERFACE HDI
873: ,HZ_PARTIES HPCUSTI
874: ,HZ_PARTIES HPCUSTN
875: ,HZ_PARTIES HPCUSTNUM
876: ,HZ_PARTIES HPTPI
877: ,HZ_PARTIES HPTPN
878: ,HZ_PARTIES HPTPNUM
879: ,JTF_RS_SALESREPS SPI

Line 876: ,HZ_PARTIES HPTPI

872: FROM OKS_HEADERS_INTERFACE HDI
873: ,HZ_PARTIES HPCUSTI
874: ,HZ_PARTIES HPCUSTN
875: ,HZ_PARTIES HPCUSTNUM
876: ,HZ_PARTIES HPTPI
877: ,HZ_PARTIES HPTPN
878: ,HZ_PARTIES HPTPNUM
879: ,JTF_RS_SALESREPS SPI
880: ,(SELECT SP.ROWID ROW_ID, SPTL.RESOURCE_NAME, SP.ORG_ID, SP.SALESREP_ID

Line 877: ,HZ_PARTIES HPTPN

873: ,HZ_PARTIES HPCUSTI
874: ,HZ_PARTIES HPCUSTN
875: ,HZ_PARTIES HPCUSTNUM
876: ,HZ_PARTIES HPTPI
877: ,HZ_PARTIES HPTPN
878: ,HZ_PARTIES HPTPNUM
879: ,JTF_RS_SALESREPS SPI
880: ,(SELECT SP.ROWID ROW_ID, SPTL.RESOURCE_NAME, SP.ORG_ID, SP.SALESREP_ID
881: FROM JTF_RS_RESOURCE_EXTNS_TL SPTL, JTF_RS_SALESREPS SP

Line 878: ,HZ_PARTIES HPTPNUM

874: ,HZ_PARTIES HPCUSTN
875: ,HZ_PARTIES HPCUSTNUM
876: ,HZ_PARTIES HPTPI
877: ,HZ_PARTIES HPTPN
878: ,HZ_PARTIES HPTPNUM
879: ,JTF_RS_SALESREPS SPI
880: ,(SELECT SP.ROWID ROW_ID, SPTL.RESOURCE_NAME, SP.ORG_ID, SP.SALESREP_ID
881: FROM JTF_RS_RESOURCE_EXTNS_TL SPTL, JTF_RS_SALESREPS SP
882: WHERE SP.RESOURCE_ID = SPTL.RESOURCE_ID

Line 2771: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC

2767: ,RA_RULES IRN
2768: ,MTL_SYSTEM_ITEMS_B MSI
2769: ,MTL_SYSTEM_ITEMS_B_KFV MSN
2770: ,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
2771: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC
2772: WHERE CAR.ROLE_TYPE = 'CONTACT'
2773: AND R.PARTY_ID = CAR.PARTY_ID
2774: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2775: AND P.PARTY_ID = R.SUBJECT_ID

Line 2780: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC

2776: AND OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
2777: AND R.DIRECTIONAL_FLAG = 'F') BCI
2778:
2779: ,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
2780: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC
2781: WHERE CAR.ROLE_TYPE = 'CONTACT'
2782: AND R.PARTY_ID = CAR.PARTY_ID
2783: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2784: AND P.PARTY_ID = R.SUBJECT_ID

Line 2788: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC

2784: AND P.PARTY_ID = R.SUBJECT_ID
2785: AND OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
2786: AND R.DIRECTIONAL_FLAG = 'F') SCI
2787: /*,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
2788: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC
2789: WHERE CAR.ROLE_TYPE = 'CONTACT'
2790: AND R.PARTY_ID = CAR.PARTY_ID
2791: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2792: AND P.PARTY_ID = R.SUBJECT_ID

Line 2796: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC

2792: AND P.PARTY_ID = R.SUBJECT_ID
2793: AND OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
2794: AND R.DIRECTIONAL_FLAG = 'F') BCN
2795: ,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
2796: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC
2797: WHERE CAR.ROLE_TYPE = 'CONTACT'
2798: AND R.PARTY_ID = CAR.PARTY_ID
2799: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2800: AND P.PARTY_ID = R.SUBJECT_ID

Line 3911: ,HZ_PARTIES HPI

3907: ,COUNT(DISTINCT HPIN.ROWID) OVER (PARTITION BY CLI.ROWID) HPIN_COUNT
3908: ,MAX(HPIN.PARTY_ID) OVER (PARTITION BY CLI.ROWID) HPIN_ID --COVERED PARTY ID Based on Name
3909:
3910: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3911: ,HZ_PARTIES HPI
3912: ,HZ_PARTIES HPINUM
3913: ,HZ_PARTIES HPIN
3914:
3915: WHERE CLI.COVERED_PARTY_ID = HPI.PARTY_ID (+)

Line 3912: ,HZ_PARTIES HPINUM

3908: ,MAX(HPIN.PARTY_ID) OVER (PARTITION BY CLI.ROWID) HPIN_ID --COVERED PARTY ID Based on Name
3909:
3910: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3911: ,HZ_PARTIES HPI
3912: ,HZ_PARTIES HPINUM
3913: ,HZ_PARTIES HPIN
3914:
3915: WHERE CLI.COVERED_PARTY_ID = HPI.PARTY_ID (+)
3916: AND CLI.COVERED_PARTY_NAME = HPIN.PARTY_NAME (+)

Line 3913: ,HZ_PARTIES HPIN

3909:
3910: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3911: ,HZ_PARTIES HPI
3912: ,HZ_PARTIES HPINUM
3913: ,HZ_PARTIES HPIN
3914:
3915: WHERE CLI.COVERED_PARTY_ID = HPI.PARTY_ID (+)
3916: AND CLI.COVERED_PARTY_NAME = HPIN.PARTY_NAME (+)
3917: AND CLI.COVERED_PARTY_NUMBER = HPINUM.PARTY_NUMBER (+))NAMEID_Q