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 813: ,HZ_CUST_SITE_USES_ALL BTSUI

809: ,rtrim(OHI.DOCUMENT) DOCUMENT
810: FROM OKS_HEADERS_INTERFACE OHI
811: ,HR_ALL_ORGANIZATION_UNITS HOU
812: ,HR_ORGANIZATION_INFORMATION HOI
813: ,HZ_CUST_SITE_USES_ALL BTSUI
814: ,HZ_CUST_SITE_USES_ALL STSUI
815: ,FND_CURRENCIES FCUR
816: ,GL_DAILY_CONVERSION_TYPES GLCT
817: ,GL_DAILY_RATES GLDR

Line 814: ,HZ_CUST_SITE_USES_ALL STSUI

810: FROM OKS_HEADERS_INTERFACE OHI
811: ,HR_ALL_ORGANIZATION_UNITS HOU
812: ,HR_ORGANIZATION_INFORMATION HOI
813: ,HZ_CUST_SITE_USES_ALL BTSUI
814: ,HZ_CUST_SITE_USES_ALL STSUI
815: ,FND_CURRENCIES FCUR
816: ,GL_DAILY_CONVERSION_TYPES GLCT
817: ,GL_DAILY_RATES GLDR
818: ,FND_LOOKUPS FL

Line 1570: HZ_CUST_SITE_USES_ALL CS,

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

Line 2851: ,HZ_CUST_SITE_USES_ALL BTSUI

2847: AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
2848: AND P.PARTY_ID = R.SUBJECT_ID
2849: AND OC.PARTY_RELATIONSHIP_ID = R.RELATIONSHIP_ID
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'

Line 2852: ,HZ_CUST_SITE_USES_ALL STSUI

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

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