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_PARTY_SITES

Line 1571: HZ_PARTY_SITES PS,

1567: UNION
1568: SELECT 'X'
1569: FROM OKS_BILLING_PROFILES_B A,
1570: HZ_CUST_SITE_USES_ALL CS,
1571: HZ_PARTY_SITES PS,
1572: HZ_CUST_ACCT_SITES_ALL CA
1573: WHERE A.ID = HST.RENEWAL_BILLING_PROFILE_ID
1574: AND A.OWNED_PARTY_ID1 = HST.CUSTOMER_PARTY_ID
1575: AND PS.PARTY_SITE_ID = CA.PARTY_SITE_ID

Line 2854: FROM HZ_CUST_SITE_USES_ALL CSU, HZ_CUST_ACCT_SITES_ALL CAS, HZ_PARTY_SITES PS, OKS_INT_HEADER_STG_TEMP HT

2850: AND R.DIRECTIONAL_FLAG = 'F') SCN */
2851: ,HZ_CUST_SITE_USES_ALL BTSUI
2852: ,HZ_CUST_SITE_USES_ALL STSUI
2853: ,(SELECT CSU.ROWID ROW_ID, CSU.SITE_USE_ID, CSU.LOCATION, HT.HEADER_INTERFACE_ID
2854: FROM HZ_CUST_SITE_USES_ALL CSU, HZ_CUST_ACCT_SITES_ALL CAS, HZ_PARTY_SITES PS, OKS_INT_HEADER_STG_TEMP HT
2855: WHERE CSU.SITE_USE_CODE = 'BILL_TO'
2856: AND CSU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID
2857: AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
2858: AND PS.PARTY_ID = HT.CUSTOMER_PARTY_ID

Line 2861: FROM HZ_CUST_SITE_USES_ALL CSU, HZ_CUST_ACCT_SITES_ALL CAS, HZ_PARTY_SITES PS, OKS_INT_HEADER_STG_TEMP HT

2857: AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
2858: AND PS.PARTY_ID = HT.CUSTOMER_PARTY_ID
2859: AND CSU.ORG_ID = HT.OPERATING_UNIT_ID) BTSUN
2860: ,(SELECT CSU.ROWID ROW_ID, CSU.SITE_USE_ID, CSU.LOCATION, HT.HEADER_INTERFACE_ID
2861: FROM HZ_CUST_SITE_USES_ALL CSU, HZ_CUST_ACCT_SITES_ALL CAS, HZ_PARTY_SITES PS, OKS_INT_HEADER_STG_TEMP HT
2862: WHERE CSU.SITE_USE_CODE = 'SHIP_TO'
2863: AND CSU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID
2864: AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
2865: AND PS.PARTY_ID = HT.CUSTOMER_PARTY_ID

Line 4070: ,HZ_PARTY_SITES CSITEID

4066: ,COUNT(DISTINCT CSITENUM.ROWID) OVER (PARTITION BY CLI.ROWID) CSITENUM_COUNT
4067: ,MAX(CSITENUM.PARTY_SITE_ID) OVER (PARTITION BY CLI.ROWID) CSITENUM_ID -- COVERED SITE ID Based on Number
4068:
4069: FROM OKS_COVERED_LEVELS_INTERFACE CLI
4070: ,HZ_PARTY_SITES CSITEID
4071: ,HZ_PARTY_SITES CSITENUM
4072:
4073: WHERE CLI.COVERED_SITE_ID = CSITEID.PARTY_SITE_ID (+)
4074: AND CLI.COVERED_SITE_NUMBER = CSITENUM.PARTY_SITE_NUMBER (+)) NAMEID_Q

Line 4071: ,HZ_PARTY_SITES CSITENUM

4067: ,MAX(CSITENUM.PARTY_SITE_ID) OVER (PARTITION BY CLI.ROWID) CSITENUM_ID -- COVERED SITE ID Based on Number
4068:
4069: FROM OKS_COVERED_LEVELS_INTERFACE CLI
4070: ,HZ_PARTY_SITES CSITEID
4071: ,HZ_PARTY_SITES CSITENUM
4072:
4073: WHERE CLI.COVERED_SITE_ID = CSITEID.PARTY_SITE_ID (+)
4074: AND CLI.COVERED_SITE_NUMBER = CSITENUM.PARTY_SITE_NUMBER (+)) NAMEID_Q
4075: