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 903: ,HZ_PARTIES HPCUSTI

899: ,HDI.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
900: ,trunc(HDI.CURRENCY_CONVERSION_DATE) CURRENCY_CONVERSION_DATE
901: ,HDI.CONTRACT_CURRENCY_CODE CONTRACT_CURRENCY_CODE
902: FROM OKS_HEADERS_INTERFACE HDI
903: ,HZ_PARTIES HPCUSTI
904: ,HZ_PARTIES HPCUSTN
905: ,HZ_PARTIES HPCUSTNUM
906: ,HZ_PARTIES HPTPI
907: ,HZ_PARTIES HPTPN

Line 904: ,HZ_PARTIES HPCUSTN

900: ,trunc(HDI.CURRENCY_CONVERSION_DATE) CURRENCY_CONVERSION_DATE
901: ,HDI.CONTRACT_CURRENCY_CODE CONTRACT_CURRENCY_CODE
902: FROM OKS_HEADERS_INTERFACE HDI
903: ,HZ_PARTIES HPCUSTI
904: ,HZ_PARTIES HPCUSTN
905: ,HZ_PARTIES HPCUSTNUM
906: ,HZ_PARTIES HPTPI
907: ,HZ_PARTIES HPTPN
908: ,HZ_PARTIES HPTPNUM

Line 905: ,HZ_PARTIES HPCUSTNUM

901: ,HDI.CONTRACT_CURRENCY_CODE CONTRACT_CURRENCY_CODE
902: FROM OKS_HEADERS_INTERFACE HDI
903: ,HZ_PARTIES HPCUSTI
904: ,HZ_PARTIES HPCUSTN
905: ,HZ_PARTIES HPCUSTNUM
906: ,HZ_PARTIES HPTPI
907: ,HZ_PARTIES HPTPN
908: ,HZ_PARTIES HPTPNUM
909: ,JTF_RS_SALESREPS SPI

Line 906: ,HZ_PARTIES HPTPI

902: FROM OKS_HEADERS_INTERFACE HDI
903: ,HZ_PARTIES HPCUSTI
904: ,HZ_PARTIES HPCUSTN
905: ,HZ_PARTIES HPCUSTNUM
906: ,HZ_PARTIES HPTPI
907: ,HZ_PARTIES HPTPN
908: ,HZ_PARTIES HPTPNUM
909: ,JTF_RS_SALESREPS SPI
910: ,(SELECT SP.ROWID ROW_ID, SPTL.RESOURCE_NAME, SP.ORG_ID, SP.SALESREP_ID

Line 907: ,HZ_PARTIES HPTPN

903: ,HZ_PARTIES HPCUSTI
904: ,HZ_PARTIES HPCUSTN
905: ,HZ_PARTIES HPCUSTNUM
906: ,HZ_PARTIES HPTPI
907: ,HZ_PARTIES HPTPN
908: ,HZ_PARTIES HPTPNUM
909: ,JTF_RS_SALESREPS SPI
910: ,(SELECT SP.ROWID ROW_ID, SPTL.RESOURCE_NAME, SP.ORG_ID, SP.SALESREP_ID
911: FROM JTF_RS_RESOURCE_EXTNS_TL SPTL, JTF_RS_SALESREPS SP

Line 908: ,HZ_PARTIES HPTPNUM

904: ,HZ_PARTIES HPCUSTN
905: ,HZ_PARTIES HPCUSTNUM
906: ,HZ_PARTIES HPTPI
907: ,HZ_PARTIES HPTPN
908: ,HZ_PARTIES HPTPNUM
909: ,JTF_RS_SALESREPS SPI
910: ,(SELECT SP.ROWID ROW_ID, SPTL.RESOURCE_NAME, SP.ORG_ID, SP.SALESREP_ID
911: FROM JTF_RS_RESOURCE_EXTNS_TL SPTL, JTF_RS_SALESREPS SP
912: WHERE SP.RESOURCE_ID = SPTL.RESOURCE_ID

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

2815: ,RA_RULES IRN
2816: ,MTL_SYSTEM_ITEMS_B MSI
2817: ,MTL_SYSTEM_ITEMS_B_KFV MSN
2818: ,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
2819: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC
2820: WHERE CAR.ROLE_TYPE = 'CONTACT'
2821: AND R.PARTY_ID = CAR.PARTY_ID
2822: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2823: AND P.PARTY_ID = R.SUBJECT_ID

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

2824: AND OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
2825: AND R.DIRECTIONAL_FLAG = 'F') BCI
2826:
2827: ,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
2828: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC
2829: WHERE CAR.ROLE_TYPE = 'CONTACT'
2830: AND R.PARTY_ID = CAR.PARTY_ID
2831: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2832: AND P.PARTY_ID = R.SUBJECT_ID

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

2832: AND P.PARTY_ID = R.SUBJECT_ID
2833: AND OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
2834: AND R.DIRECTIONAL_FLAG = 'F') SCI
2835: /*,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
2836: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC
2837: WHERE CAR.ROLE_TYPE = 'CONTACT'
2838: AND R.PARTY_ID = CAR.PARTY_ID
2839: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2840: AND P.PARTY_ID = R.SUBJECT_ID

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

2840: AND P.PARTY_ID = R.SUBJECT_ID
2841: AND OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
2842: AND R.DIRECTIONAL_FLAG = 'F') BCN
2843: ,(SELECT CAR.ROWID ROW_ID, CAR.CUST_ACCOUNT_ROLE_ID CONTACT_ID, P.PARTY_NAME CONTACT_NAME, R.OBJECT_ID PARTY_ID
2844: FROM HZ_CUST_ACCOUNT_ROLES CAR,HZ_PARTIES P, HZ_RELATIONSHIPS R , HZ_ORG_CONTACTS OC
2845: WHERE CAR.ROLE_TYPE = 'CONTACT'
2846: AND R.PARTY_ID = CAR.PARTY_ID
2847: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2848: AND P.PARTY_ID = R.SUBJECT_ID

Line 3963: ,HZ_PARTIES HPI

3959: ,COUNT(DISTINCT HPIN.ROWID) OVER (PARTITION BY CLI.ROWID) HPIN_COUNT
3960: ,MAX(HPIN.PARTY_ID) OVER (PARTITION BY CLI.ROWID) HPIN_ID --COVERED PARTY ID Based on Name
3961:
3962: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3963: ,HZ_PARTIES HPI
3964: ,HZ_PARTIES HPINUM
3965: ,HZ_PARTIES HPIN
3966:
3967: WHERE CLI.COVERED_PARTY_ID = HPI.PARTY_ID (+)

Line 3964: ,HZ_PARTIES HPINUM

3960: ,MAX(HPIN.PARTY_ID) OVER (PARTITION BY CLI.ROWID) HPIN_ID --COVERED PARTY ID Based on Name
3961:
3962: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3963: ,HZ_PARTIES HPI
3964: ,HZ_PARTIES HPINUM
3965: ,HZ_PARTIES HPIN
3966:
3967: WHERE CLI.COVERED_PARTY_ID = HPI.PARTY_ID (+)
3968: AND CLI.COVERED_PARTY_NAME = HPIN.PARTY_NAME (+)

Line 3965: ,HZ_PARTIES HPIN

3961:
3962: FROM OKS_COVERED_LEVELS_INTERFACE CLI
3963: ,HZ_PARTIES HPI
3964: ,HZ_PARTIES HPINUM
3965: ,HZ_PARTIES HPIN
3966:
3967: WHERE CLI.COVERED_PARTY_ID = HPI.PARTY_ID (+)
3968: AND CLI.COVERED_PARTY_NAME = HPIN.PARTY_NAME (+)
3969: AND CLI.COVERED_PARTY_NUMBER = HPINUM.PARTY_NUMBER (+))NAMEID_Q