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 1651: || ' , MTL_SYSTEM_ITEMS_B IT '

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

Line 1675: ||' , MTL_SYSTEM_ITEMS_B IT '

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

Line 1707: ||' , MTL_SYSTEM_ITEMS_B IT '

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

Line 1736: ||' , MTL_SYSTEM_ITEMS_B IT '

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

Line 1903: ||' MTL_SYSTEM_ITEMS_B IT '

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

Line 1931: ||' , MTL_SYSTEM_ITEMS_B IT '

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

Line 1965: ||' , MTL_SYSTEM_ITEMS_B IT '

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

Line 4194: FROM mtl_system_items_b

4190: --FROM okx_system_items_v
4191: --WHERE id1 = p_item_id
4192: --AND id2 = OKC_CONTEXT.GET_OKC_ORGANIZATION_ID;
4193: SELECT COVERAGE_SCHEDULE_ID
4194: FROM mtl_system_items_b
4195: WHERE inventory_item_id = p_item_id
4196: AND organization_id = nvl(l_org_id, -99) ;
4197:
4198: