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 868: , CSI_INSTANCE_STATUSES CIS

864: , OOL.unit_selling_price
865: , '#' id2
866: , CII.external_reference -- bug 4372877
867: FROM CSI_ITEM_INSTANCES CII
868: , CSI_INSTANCE_STATUSES CIS
869: , OE_ORDER_LINES_ALL OOL
870: , OKX_SYSTEM_ITEMS_V IT
871: WHERE CII.INSTANCE_ID = p_instance_id
872: AND CII.inventory_item_id = IT.id1

Line 1650: || ' CSI_INSTANCE_STATUSES CIS '

1646: || ' CSI_SYSTEMS_TL CST '
1647: || ' WHERE CSB.system_id = CST.system_id '
1648: || ' AND CSB.system_id IN (Select CII.system_id '
1649: || ' From CSI_ITEM_INSTANCES CII, '
1650: || ' CSI_INSTANCE_STATUSES CIS '
1651: || ' , MTL_SYSTEM_ITEMS_B IT '
1652: || ' WHERE IT.inventory_item_id = CII.inventory_item_id '
1653: || ' AND IT.serviceable_product_flag = ''Y'''
1654: || ' AND IT.organization_id = :l_organization_id '

Line 1674: ||' CSI_INSTANCE_STATUSES CIS '

1670: || ' WHERE CSB.system_id = CST.system_id '
1671: || ' AND CSB.system_id IN '
1672: ||' (SELECT CII.system_id '
1673: ||' FROM CSI_ITEM_INSTANCES CII, '
1674: ||' CSI_INSTANCE_STATUSES CIS '
1675: ||' , MTL_SYSTEM_ITEMS_B IT '
1676: || ' WHERE IT.inventory_item_id = CII.inventory_item_id '
1677: || ' AND IT.serviceable_product_flag = ''Y'''
1678: || ' AND IT.organization_id = :l_organization_id '

Line 1706: || ' CSI_INSTANCE_STATUSES CIS '

1702: || ' CSI_SYSTEMS_TL CST '
1703: || ' WHERE CSB.system_id = CST.system_id '
1704: || ' AND CSB.system_id IN (Select CII.system_id '
1705: || ' From CSI_ITEM_INSTANCES CII, '
1706: || ' CSI_INSTANCE_STATUSES CIS '
1707: ||' , MTL_SYSTEM_ITEMS_B IT '
1708: || ' WHERE IT.inventory_item_id = CII.inventory_item_id '
1709: || ' AND IT.serviceable_product_flag = ''Y'''
1710: || ' AND IT.organization_id = :l_organization_id '

Line 1735: || ' CSI_INSTANCE_STATUSES CIS '

1731: || ' CSI_SYSTEMS_TL CST '
1732: || ' WHERE CSB.system_id = CST.system_id '
1733: || ' AND CSB.system_id IN (Select CII.system_id '
1734: || ' From CSI_ITEM_INSTANCES CII, '
1735: || ' CSI_INSTANCE_STATUSES CIS '
1736: ||' , MTL_SYSTEM_ITEMS_B IT '
1737: || ' WHERE IT.inventory_item_id = CII.inventory_item_id '
1738: || ' AND IT.serviceable_product_flag = ''Y'''
1739: || ' AND IT.organization_id = :l_organization_id '

Line 1902: ||' CSI_INSTANCE_STATUSES CIS, '

1898: l_get_all_sites_sql_c := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
1899: || ' FROM OKX_PARTY_SITES_V SI '
1900: || ' WHERE exists (SELECT CII.install_location_Id '
1901: ||' FROM CSI_ITEM_INSTANCES CII, '
1902: ||' CSI_INSTANCE_STATUSES CIS, '
1903: ||' MTL_SYSTEM_ITEMS_B IT '
1904: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
1905: ||' AND IT.serviceable_product_flag = ''Y'''
1906: ||' AND IT.organization_id = :l_organization_id '

Line 1930: ||' CSI_INSTANCE_STATUSES CIS '

1926: l_get_all_sites_sql_r := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
1927: || ' FROM OKX_PARTY_SITES_V SI '
1928: || ' WHERE exists (SELECT CII.install_location_Id '
1929: ||' FROM CSI_ITEM_INSTANCES CII, '
1930: ||' CSI_INSTANCE_STATUSES CIS '
1931: ||' , MTL_SYSTEM_ITEMS_B IT '
1932: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
1933: ||' AND IT.serviceable_product_flag = ''Y'''
1934: ||' AND IT.organization_id = :l_organization_id '

Line 1964: ||' CSI_INSTANCE_STATUSES CIS '

1960: l_get_all_sites_sql_b := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
1961: || ' FROM OKX_PARTY_SITES_V SI '
1962: || ' WHERE exists (SELECT CII.install_location_Id '
1963: || ' FROM CSI_ITEM_INSTANCES CII, '
1964: ||' CSI_INSTANCE_STATUSES CIS '
1965: ||' , MTL_SYSTEM_ITEMS_B IT '
1966: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
1967: ||' AND IT.serviceable_product_flag = ''Y'''
1968: ||' AND IT.organization_id = :l_organization_id '

Line 2000: ||' CSI_INSTANCE_STATUSES CIS '

1996: l_get_all_sites_sql_a := ' SELECT SI.Id1 id1 , SI.name name , SI.Party_Site_Number party_site_number , SI.description description '
1997: || ' FROM OKX_PARTY_SITES_V SI '
1998: || ' WHERE exists (SELECT CII.install_location_Id '
1999: || ' FROM CSI_ITEM_INSTANCES CII, '
2000: ||' CSI_INSTANCE_STATUSES CIS '
2001: ||' , MTL_SYSTEM_ITEMS_KFV IT '
2002: ||' WHERE IT.inventory_item_id = CII.inventory_item_id '
2003: ||' AND IT.serviceable_product_flag = ''Y'''
2004: ||' AND IT.organization_id = :l_organization_id '