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_CUST_SITE_USES_ALL

Line 795: ,HZ_CUST_SITE_USES_ALL BTSUI

791: ,rtrim(OHI.DOCUMENT) DOCUMENT
792: FROM OKS_HEADERS_INTERFACE OHI
793: ,HR_ALL_ORGANIZATION_UNITS HOU
794: ,HR_ORGANIZATION_INFORMATION HOI
795: ,HZ_CUST_SITE_USES_ALL BTSUI
796: ,HZ_CUST_SITE_USES_ALL STSUI
797: ,FND_CURRENCIES FCUR
798: ,GL_DAILY_CONVERSION_TYPES GLCT
799: ,GL_DAILY_RATES GLDR

Line 796: ,HZ_CUST_SITE_USES_ALL STSUI

792: FROM OKS_HEADERS_INTERFACE OHI
793: ,HR_ALL_ORGANIZATION_UNITS HOU
794: ,HR_ORGANIZATION_INFORMATION HOI
795: ,HZ_CUST_SITE_USES_ALL BTSUI
796: ,HZ_CUST_SITE_USES_ALL STSUI
797: ,FND_CURRENCIES FCUR
798: ,GL_DAILY_CONVERSION_TYPES GLCT
799: ,GL_DAILY_RATES GLDR
800: ,FND_LOOKUPS FL

Line 1540: HZ_CUST_SITE_USES_ALL CS,

1536: BILL_TO_ADDRESS_ID1 IS NULL))
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

Line 2803: ,HZ_CUST_SITE_USES_ALL BTSUI

2799: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2800: AND P.PARTY_ID = R.SUBJECT_ID
2801: AND OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
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'

Line 2804: ,HZ_CUST_SITE_USES_ALL STSUI

2800: AND P.PARTY_ID = R.SUBJECT_ID
2801: AND OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
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

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