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 OKS_BILLING_PROFILES_B

Line 1562: FROM OKS_BILLING_PROFILES_B

1558: ,(CASE WHEN (HST.RENEWAL_MARKUP IS NOT NULL AND HST.PRICING_METHOD <> 'PCT')
1559: THEN 'Y' ELSE 'N' END) MKP_NULL_ERROR
1560: ,(CASE WHEN (HST.RENEWAL_BILLING_PROFILE_ID IS NOT NULL
1561: AND NOT EXISTS (SELECT 'X'
1562: FROM OKS_BILLING_PROFILES_B
1563: WHERE ID = HST.RENEWAL_BILLING_PROFILE_ID
1564: AND (OWNED_PARTY_ID1 IS NULL
1565: OR (OWNED_PARTY_ID1 = HST.CUSTOMER_PARTY_ID AND
1566: BILL_TO_ADDRESS_ID1 IS NULL))

Line 1569: FROM OKS_BILLING_PROFILES_B A,

1565: OR (OWNED_PARTY_ID1 = HST.CUSTOMER_PARTY_ID AND
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