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_AUTH_UTIL_PVT dependencies on CSI_INSTANCE_STATUSES

Line 302: CSI_INSTANCE_STATUSES CIS

298: CII.serial_number,
299: '#' id2,
300: CII.last_oe_order_line_id
301: FROM CSI_ITEM_INSTANCES CII,
302: CSI_INSTANCE_STATUSES CIS
303: WHERE CII.owner_party_account_id IN
304: (SELECT id1 FROM okx_customer_accounts_v
305: WHERE party_id = p_party_id)
306: AND CII.Instance_status_id = CIS.instance_status_id

Line 343: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS '

339: ||', CII.serial_number serial_number '
340: ||', ''#'' id2 '
341: ||', CII.last_oe_order_line_id '
342: ||', CII.external_reference ' -- new bug 4372877
343: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS '
344: ||' WHERE '
345: ||' CIS.instance_status_id = CII.instance_status_id '
346: ||' AND CIS.service_order_allowed_flag = ''Y''' ;
347:

Line 364: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS , MTL_SYSTEM_ITEMS_KFV IT'

360: ||', CII.serial_number serial_number '
361: ||', ''#'' id2 '
362: ||', CII.last_oe_order_line_id '
363: ||', CII.external_reference ' -- new bug 4372877
364: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS , MTL_SYSTEM_ITEMS_KFV IT'
365: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
366: ||' AND IT.serviceable_product_flag = ''Y'''
367: ||' AND IT.organization_id = :p_organization_id '
368: ||' AND CIS.instance_status_id = CII.instance_status_id '

Line 388: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS , MTL_SYSTEM_ITEMS_KFV IT'

384: ||', CII.serial_number serial_number '
385: ||', ''#'' id2 '
386: ||', last_oe_order_line_id '
387: ||', CII.external_reference ' -- new bug 4372877
388: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS , MTL_SYSTEM_ITEMS_KFV IT'
389: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
390: ||' AND IT.serviceable_product_flag = ''Y'''
391: ||' AND IT.organization_id = :p_organization_id '
392: ||' AND '

Line 419: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS , MTL_SYSTEM_ITEMS_KFV IT'

415: ||', CII.serial_number serial_number '
416: ||', ''#'' id2 '
417: ||', last_oe_order_line_id '
418: ||', CII.external_reference ' -- new bug 4372877
419: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS , MTL_SYSTEM_ITEMS_KFV IT'
420: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
421: ||' AND IT.serviceable_product_flag = ''Y'''
422: ||' AND IT.organization_id = :p_organization_id '
423: ||' AND '

Line 453: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS , MTL_SYSTEM_ITEMS_KFV IT'

449: ||', CII.serial_number serial_number '
450: ||', ''#'' id2 '
451: ||', CII.last_oe_order_line_id '
452: ||', CII.external_reference ' -- new bug 4372877
453: ||' FROM CSI_ITEM_INSTANCES CII, CSI_INSTANCE_STATUSES CIS , MTL_SYSTEM_ITEMS_KFV IT'
454: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
455: ||' AND IT.serviceable_product_flag = ''Y'''
456: ||' AND IT.organization_id = :p_organization_id '
457: ||' AND '

Line 951: , CSI_INSTANCE_STATUSES CIS

947: , OOL.unit_selling_price
948: , '#' id2
949: , CII.external_reference -- bug 4372877
950: FROM CSI_ITEM_INSTANCES CII
951: , CSI_INSTANCE_STATUSES CIS
952: , OE_ORDER_LINES_ALL OOL
953: , OKX_SYSTEM_ITEMS_V IT
954: WHERE CII.INSTANCE_ID = p_instance_id
955: AND CII.inventory_item_id = IT.id1

Line 1447: CSI_INSTANCE_STATUSES CIS,

1443: OOL.unit_selling_price,
1444: '#' id2,
1445: CII.external_reference -- bug 4372877
1446: FROM CSI_ITEM_INSTANCES CII,
1447: CSI_INSTANCE_STATUSES CIS,
1448: OE_ORDER_LINES_ALL OOL,
1449: OKX_SYSTEM_ITEMS_V IT
1450: WHERE CII.INSTANCE_ID = p_instance_id
1451: AND CII.inventory_item_id = IT.id1

Line 2178: || ' CSI_INSTANCE_STATUSES CIS '

2174: || ' CSI_SYSTEMS_TL CST '
2175: || ' WHERE CSB.system_id = CST.system_id '
2176: || ' AND CSB.system_id IN (Select CII.system_id '
2177: || ' From CSI_ITEM_INSTANCES CII, '
2178: || ' CSI_INSTANCE_STATUSES CIS '
2179: || ' , MTL_SYSTEM_ITEMS_B IT '
2180: || ' WHERE IT.inventory_item_id = CII.inventory_item_id '
2181: || ' AND IT.serviceable_product_flag = ''Y'''
2182: || ' AND IT.organization_id = :l_organization_id '

Line 2202: ||' CSI_INSTANCE_STATUSES CIS '

2198: || ' WHERE CSB.system_id = CST.system_id '
2199: || ' AND CSB.system_id IN '
2200: ||' (SELECT CII.system_id '
2201: ||' FROM CSI_ITEM_INSTANCES CII, '
2202: ||' CSI_INSTANCE_STATUSES CIS '
2203: ||' , MTL_SYSTEM_ITEMS_B IT '
2204: || ' WHERE IT.inventory_item_id = CII.inventory_item_id '
2205: || ' AND IT.serviceable_product_flag = ''Y'''
2206: || ' AND IT.organization_id = :l_organization_id '

Line 2234: || ' CSI_INSTANCE_STATUSES CIS '

2230: || ' CSI_SYSTEMS_TL CST '
2231: || ' WHERE CSB.system_id = CST.system_id '
2232: || ' AND CSB.system_id IN (Select CII.system_id '
2233: || ' From CSI_ITEM_INSTANCES CII, '
2234: || ' CSI_INSTANCE_STATUSES CIS '
2235: ||' , MTL_SYSTEM_ITEMS_B IT '
2236: || ' WHERE IT.inventory_item_id = CII.inventory_item_id '
2237: || ' AND IT.serviceable_product_flag = ''Y'''
2238: || ' AND IT.organization_id = :l_organization_id '

Line 2263: || ' CSI_INSTANCE_STATUSES CIS '

2259: || ' CSI_SYSTEMS_TL CST '
2260: || ' WHERE CSB.system_id = CST.system_id '
2261: || ' AND CSB.system_id IN (Select CII.system_id '
2262: || ' From CSI_ITEM_INSTANCES CII, '
2263: || ' CSI_INSTANCE_STATUSES CIS '
2264: ||' , MTL_SYSTEM_ITEMS_B IT '
2265: || ' WHERE IT.inventory_item_id = CII.inventory_item_id '
2266: || ' AND IT.serviceable_product_flag = ''Y'''
2267: || ' AND IT.organization_id = :l_organization_id '

Line 2430: ||' CSI_INSTANCE_STATUSES CIS, '

2426: l_get_all_sites_sql_c := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
2427: || ' FROM OKX_PARTY_SITES_V SI '
2428: || ' WHERE exists (SELECT CII.install_location_Id '
2429: ||' FROM CSI_ITEM_INSTANCES CII, '
2430: ||' CSI_INSTANCE_STATUSES CIS, '
2431: ||' MTL_SYSTEM_ITEMS_B IT '
2432: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
2433: ||' AND IT.serviceable_product_flag = ''Y'''
2434: ||' AND IT.organization_id = :l_organization_id '

Line 2458: ||' CSI_INSTANCE_STATUSES CIS '

2454: l_get_all_sites_sql_r := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
2455: || ' FROM OKX_PARTY_SITES_V SI '
2456: || ' WHERE exists (SELECT CII.install_location_Id '
2457: ||' FROM CSI_ITEM_INSTANCES CII, '
2458: ||' CSI_INSTANCE_STATUSES CIS '
2459: ||' , MTL_SYSTEM_ITEMS_B IT '
2460: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
2461: ||' AND IT.serviceable_product_flag = ''Y'''
2462: ||' AND IT.organization_id = :l_organization_id '

Line 2492: ||' CSI_INSTANCE_STATUSES CIS '

2488: l_get_all_sites_sql_b := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
2489: || ' FROM OKX_PARTY_SITES_V SI '
2490: || ' WHERE exists (SELECT CII.install_location_Id '
2491: || ' FROM CSI_ITEM_INSTANCES CII, '
2492: ||' CSI_INSTANCE_STATUSES CIS '
2493: ||' , MTL_SYSTEM_ITEMS_B IT '
2494: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
2495: ||' AND IT.serviceable_product_flag = ''Y'''
2496: ||' AND IT.organization_id = :l_organization_id '

Line 2528: ||' CSI_INSTANCE_STATUSES CIS '

2524: l_get_all_sites_sql_a := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
2525: || ' FROM OKX_PARTY_SITES_V SI '
2526: || ' WHERE exists (SELECT CII.install_location_Id '
2527: || ' FROM CSI_ITEM_INSTANCES CII, '
2528: ||' CSI_INSTANCE_STATUSES CIS '
2529: ||' , MTL_SYSTEM_ITEMS_KFV IT '
2530: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
2531: ||' AND IT.serviceable_product_flag = ''Y'''
2532: ||' AND IT.organization_id = :l_organization_id '