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 MTL_SYSTEM_ITEMS_B

Line 2179: || ' , MTL_SYSTEM_ITEMS_B IT '

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 '
2183: || ' AND CII.owner_party_account_id in (select cust_account_id '

Line 2203: ||' , MTL_SYSTEM_ITEMS_B IT '

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 '
2207: || ' AND CII.owner_party_account_id in (select cust_account_id '

Line 2235: ||' , MTL_SYSTEM_ITEMS_B IT '

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 '
2239: || ' AND CII.owner_party_account_id in '

Line 2264: ||' , MTL_SYSTEM_ITEMS_B IT '

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 '
2268: || ' AND CIS.instance_status_id = CII.instance_status_id '

Line 2431: ||' MTL_SYSTEM_ITEMS_B IT '

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 '
2435: ||' AND CII.install_location_id = SI.id1 '

Line 2459: ||' , MTL_SYSTEM_ITEMS_B IT '

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 '
2463: ||' AND CII.install_location_id = SI.id1 '

Line 2493: ||' , MTL_SYSTEM_ITEMS_B IT '

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 '
2497: ||' AND CII.install_location_id = SI.id1 '

Line 4734: FROM mtl_system_items_b

4730: --FROM okx_system_items_v
4731: --WHERE id1 = p_item_id
4732: --AND id2 = OKC_CONTEXT.GET_OKC_ORGANIZATION_ID;
4733: SELECT COVERAGE_SCHEDULE_ID
4734: FROM mtl_system_items_b
4735: WHERE inventory_item_id = p_item_id
4736: AND organization_id = nvl(l_org_id, -99) ;
4737:
4738: