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.OKL_CNTRCT_FIN_EXTRACT_PVT dependencies on AR_LOOKUPS

Line 1098: ar_lookups ar_lookup_status,

1094: ) where cpsu_stat_priority = 1) cust_party_site_use,
1095:
1096: hz_cust_site_uses_all cust_cust_site_use,
1097:
1098: ar_lookups ar_lookup_status,
1099: ar_lookups ar_lookup_acc_status,
1100: ar_lookups ar_lookup_cust_type,
1101: ar_lookups ar_lookup_cust_site,
1102: ar_lookups ar_lookup_cust_site_use

Line 1099: ar_lookups ar_lookup_acc_status,

1095:
1096: hz_cust_site_uses_all cust_cust_site_use,
1097:
1098: ar_lookups ar_lookup_status,
1099: ar_lookups ar_lookup_acc_status,
1100: ar_lookups ar_lookup_cust_type,
1101: ar_lookups ar_lookup_cust_site,
1102: ar_lookups ar_lookup_cust_site_use
1103:

Line 1100: ar_lookups ar_lookup_cust_type,

1096: hz_cust_site_uses_all cust_cust_site_use,
1097:
1098: ar_lookups ar_lookup_status,
1099: ar_lookups ar_lookup_acc_status,
1100: ar_lookups ar_lookup_cust_type,
1101: ar_lookups ar_lookup_cust_site,
1102: ar_lookups ar_lookup_cust_site_use
1103:
1104: WHERE chr.id = khr.id

Line 1101: ar_lookups ar_lookup_cust_site,

1097:
1098: ar_lookups ar_lookup_status,
1099: ar_lookups ar_lookup_acc_status,
1100: ar_lookups ar_lookup_cust_type,
1101: ar_lookups ar_lookup_cust_site,
1102: ar_lookups ar_lookup_cust_site_use
1103:
1104: WHERE chr.id = khr.id
1105: AND chr.SCS_CODE = 'LEASE'

Line 1102: ar_lookups ar_lookup_cust_site_use

1098: ar_lookups ar_lookup_status,
1099: ar_lookups ar_lookup_acc_status,
1100: ar_lookups ar_lookup_cust_type,
1101: ar_lookups ar_lookup_cust_site,
1102: ar_lookups ar_lookup_cust_site_use
1103:
1104: WHERE chr.id = khr.id
1105: AND chr.SCS_CODE = 'LEASE'
1106: AND opp.object_type = 'CONTRACT_FIN_EXTRACT'

Line 2128: ar_lookups ar_lookup_status,

2124: hz_cust_site_uses_all cust_cust_site_use,
2125:
2126: hz_cust_acct_sites_all cust_cust_acct_site,
2127:
2128: ar_lookups ar_lookup_status,
2129: ar_lookups ar_lookup_acc_status,
2130: ar_lookups ar_lookup_cust_type,
2131: ar_lookups ar_lookup_cust_site,
2132: ar_lookups ar_lookup_cust_site_use

Line 2129: ar_lookups ar_lookup_acc_status,

2125:
2126: hz_cust_acct_sites_all cust_cust_acct_site,
2127:
2128: ar_lookups ar_lookup_status,
2129: ar_lookups ar_lookup_acc_status,
2130: ar_lookups ar_lookup_cust_type,
2131: ar_lookups ar_lookup_cust_site,
2132: ar_lookups ar_lookup_cust_site_use
2133:

Line 2130: ar_lookups ar_lookup_cust_type,

2126: hz_cust_acct_sites_all cust_cust_acct_site,
2127:
2128: ar_lookups ar_lookup_status,
2129: ar_lookups ar_lookup_acc_status,
2130: ar_lookups ar_lookup_cust_type,
2131: ar_lookups ar_lookup_cust_site,
2132: ar_lookups ar_lookup_cust_site_use
2133:
2134: WHERE chr.id = khr.id

Line 2131: ar_lookups ar_lookup_cust_site,

2127:
2128: ar_lookups ar_lookup_status,
2129: ar_lookups ar_lookup_acc_status,
2130: ar_lookups ar_lookup_cust_type,
2131: ar_lookups ar_lookup_cust_site,
2132: ar_lookups ar_lookup_cust_site_use
2133:
2134: WHERE chr.id = khr.id
2135: AND chr.SCS_CODE = 'LEASE'

Line 2132: ar_lookups ar_lookup_cust_site_use

2128: ar_lookups ar_lookup_status,
2129: ar_lookups ar_lookup_acc_status,
2130: ar_lookups ar_lookup_cust_type,
2131: ar_lookups ar_lookup_cust_site,
2132: ar_lookups ar_lookup_cust_site_use
2133:
2134: WHERE chr.id = khr.id
2135: AND chr.SCS_CODE = 'LEASE'
2136: AND opp.object_type = 'CONTRACT_FIN_EXTRACT'