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 1541: HZ_PARTY_SITES PS,

1537: UNION
1538: SELECT 'X'
1539: FROM OKS_BILLING_PROFILES_B A,
1540: HZ_CUST_SITE_USES_ALL CS,
1541: HZ_PARTY_SITES PS,
1542: HZ_CUST_ACCT_SITES_ALL CA
1543: WHERE A.ID = HST.RENEWAL_BILLING_PROFILE_ID
1544: AND A.OWNED_PARTY_ID1 = HST.CUSTOMER_PARTY_ID
1545: AND PS.PARTY_SITE_ID = CA.PARTY_SITE_ID

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

2802: AND R.DIRECTIONAL_FLAG = 'F') SCN */
2803: ,HZ_CUST_SITE_USES_ALL BTSUI
2804: ,HZ_CUST_SITE_USES_ALL STSUI
2805: ,(SELECT CSU.ROWID ROW_ID, CSU.SITE_USE_ID, CSU.LOCATION, HT.HEADER_INTERFACE_ID
2806: FROM HZ_CUST_SITE_USES_ALL CSU, HZ_CUST_ACCT_SITES_ALL CAS, HZ_PARTY_SITES PS, OKS_INT_HEADER_STG_TEMP HT
2807: WHERE CSU.SITE_USE_CODE = 'BILL_TO'
2808: AND CSU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID
2809: AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
2810: AND PS.PARTY_ID = HT.CUSTOMER_PARTY_ID

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

2809: AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
2810: AND PS.PARTY_ID = HT.CUSTOMER_PARTY_ID
2811: AND CSU.ORG_ID = HT.OPERATING_UNIT_ID) BTSUN
2812: ,(SELECT CSU.ROWID ROW_ID, CSU.SITE_USE_ID, CSU.LOCATION, HT.HEADER_INTERFACE_ID
2813: FROM HZ_CUST_SITE_USES_ALL CSU, HZ_CUST_ACCT_SITES_ALL CAS, HZ_PARTY_SITES PS, OKS_INT_HEADER_STG_TEMP HT
2814: WHERE CSU.SITE_USE_CODE = 'SHIP_TO'
2815: AND CSU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID
2816: AND PS.PARTY_SITE_ID = CAS.PARTY_SITE_ID
2817: AND PS.PARTY_ID = HT.CUSTOMER_PARTY_ID

Line 4018: ,HZ_PARTY_SITES CSITEID

4014: ,COUNT(DISTINCT CSITENUM.ROWID) OVER (PARTITION BY CLI.ROWID) CSITENUM_COUNT
4015: ,MAX(CSITENUM.PARTY_SITE_ID) OVER (PARTITION BY CLI.ROWID) CSITENUM_ID -- COVERED SITE ID Based on Number
4016:
4017: FROM OKS_COVERED_LEVELS_INTERFACE CLI
4018: ,HZ_PARTY_SITES CSITEID
4019: ,HZ_PARTY_SITES CSITENUM
4020:
4021: WHERE CLI.COVERED_SITE_ID = CSITEID.PARTY_SITE_ID (+)
4022: AND CLI.COVERED_SITE_NUMBER = CSITENUM.PARTY_SITE_NUMBER (+)) NAMEID_Q

Line 4019: ,HZ_PARTY_SITES CSITENUM

4015: ,MAX(CSITENUM.PARTY_SITE_ID) OVER (PARTITION BY CLI.ROWID) CSITENUM_ID -- COVERED SITE ID Based on Number
4016:
4017: FROM OKS_COVERED_LEVELS_INTERFACE CLI
4018: ,HZ_PARTY_SITES CSITEID
4019: ,HZ_PARTY_SITES CSITENUM
4020:
4021: WHERE CLI.COVERED_SITE_ID = CSITEID.PARTY_SITE_ID (+)
4022: AND CLI.COVERED_SITE_NUMBER = CSITENUM.PARTY_SITE_NUMBER (+)) NAMEID_Q
4023: