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 1084: ar_lookups ar_lookup_status,

1080: ) where cpsu_stat_priority = 1) cust_party_site_use,
1081:
1082: hz_cust_site_uses_all cust_cust_site_use,
1083:
1084: ar_lookups ar_lookup_status,
1085: ar_lookups ar_lookup_acc_status,
1086: ar_lookups ar_lookup_cust_type,
1087: ar_lookups ar_lookup_cust_site,
1088: ar_lookups ar_lookup_cust_site_use

Line 1085: ar_lookups ar_lookup_acc_status,

1081:
1082: hz_cust_site_uses_all cust_cust_site_use,
1083:
1084: ar_lookups ar_lookup_status,
1085: ar_lookups ar_lookup_acc_status,
1086: ar_lookups ar_lookup_cust_type,
1087: ar_lookups ar_lookup_cust_site,
1088: ar_lookups ar_lookup_cust_site_use
1089:

Line 1086: ar_lookups ar_lookup_cust_type,

1082: hz_cust_site_uses_all cust_cust_site_use,
1083:
1084: ar_lookups ar_lookup_status,
1085: ar_lookups ar_lookup_acc_status,
1086: ar_lookups ar_lookup_cust_type,
1087: ar_lookups ar_lookup_cust_site,
1088: ar_lookups ar_lookup_cust_site_use
1089:
1090: WHERE chr.id = khr.id

Line 1087: ar_lookups ar_lookup_cust_site,

1083:
1084: ar_lookups ar_lookup_status,
1085: ar_lookups ar_lookup_acc_status,
1086: ar_lookups ar_lookup_cust_type,
1087: ar_lookups ar_lookup_cust_site,
1088: ar_lookups ar_lookup_cust_site_use
1089:
1090: WHERE chr.id = khr.id
1091: AND chr.SCS_CODE = 'LEASE'

Line 1088: ar_lookups ar_lookup_cust_site_use

1084: ar_lookups ar_lookup_status,
1085: ar_lookups ar_lookup_acc_status,
1086: ar_lookups ar_lookup_cust_type,
1087: ar_lookups ar_lookup_cust_site,
1088: ar_lookups ar_lookup_cust_site_use
1089:
1090: WHERE chr.id = khr.id
1091: AND chr.SCS_CODE = 'LEASE'
1092: AND opp.object_type = 'CONTRACT_FIN_EXTRACT'

Line 2114: ar_lookups ar_lookup_status,

2110: hz_cust_site_uses_all cust_cust_site_use,
2111:
2112: hz_cust_acct_sites_all cust_cust_acct_site,
2113:
2114: ar_lookups ar_lookup_status,
2115: ar_lookups ar_lookup_acc_status,
2116: ar_lookups ar_lookup_cust_type,
2117: ar_lookups ar_lookup_cust_site,
2118: ar_lookups ar_lookup_cust_site_use

Line 2115: ar_lookups ar_lookup_acc_status,

2111:
2112: hz_cust_acct_sites_all cust_cust_acct_site,
2113:
2114: ar_lookups ar_lookup_status,
2115: ar_lookups ar_lookup_acc_status,
2116: ar_lookups ar_lookup_cust_type,
2117: ar_lookups ar_lookup_cust_site,
2118: ar_lookups ar_lookup_cust_site_use
2119:

Line 2116: ar_lookups ar_lookup_cust_type,

2112: hz_cust_acct_sites_all cust_cust_acct_site,
2113:
2114: ar_lookups ar_lookup_status,
2115: ar_lookups ar_lookup_acc_status,
2116: ar_lookups ar_lookup_cust_type,
2117: ar_lookups ar_lookup_cust_site,
2118: ar_lookups ar_lookup_cust_site_use
2119:
2120: WHERE chr.id = khr.id

Line 2117: ar_lookups ar_lookup_cust_site,

2113:
2114: ar_lookups ar_lookup_status,
2115: ar_lookups ar_lookup_acc_status,
2116: ar_lookups ar_lookup_cust_type,
2117: ar_lookups ar_lookup_cust_site,
2118: ar_lookups ar_lookup_cust_site_use
2119:
2120: WHERE chr.id = khr.id
2121: AND chr.SCS_CODE = 'LEASE'

Line 2118: ar_lookups ar_lookup_cust_site_use

2114: ar_lookups ar_lookup_status,
2115: ar_lookups ar_lookup_acc_status,
2116: ar_lookups ar_lookup_cust_type,
2117: ar_lookups ar_lookup_cust_site,
2118: ar_lookups ar_lookup_cust_site_use
2119:
2120: WHERE chr.id = khr.id
2121: AND chr.SCS_CODE = 'LEASE'
2122: AND opp.object_type = 'CONTRACT_FIN_EXTRACT'