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.ENI_ITEMS_STAR_PKG dependencies on MTL_ITEM_CATEGORIES

Line 40: mtl_item_categories cat

36: COUNT(category_id)
37: FROM
38: mtl_system_items_kfv mti,
39: -- mtl_parameters mtp,
40: mtl_item_categories cat
41: WHERE
42: mti.inventory_item_id = cat.inventory_item_id AND
43: mti.organization_id = cat.organization_id AND
44: -- mtp.organization_id = mti.organization_id AND

Line 434: mtl_item_categories mic ,

430: mti.volume_uom_code,
431: mti.eam_item_type
432: FROM mtl_system_items_b_kfv mti,
433: mtl_parameters mtp,
434: mtl_item_categories mic ,
435: mtl_item_categories mic1 ,
436: mtl_item_categories mic2 ,
437: mtl_categories_b_kfv kfv ,
438: mtl_categories_b_kfv kfv1,

Line 435: mtl_item_categories mic1 ,

431: mti.eam_item_type
432: FROM mtl_system_items_b_kfv mti,
433: mtl_parameters mtp,
434: mtl_item_categories mic ,
435: mtl_item_categories mic1 ,
436: mtl_item_categories mic2 ,
437: mtl_categories_b_kfv kfv ,
438: mtl_categories_b_kfv kfv1,
439: mtl_categories_b_kfv kfv2

Line 436: mtl_item_categories mic2 ,

432: FROM mtl_system_items_b_kfv mti,
433: mtl_parameters mtp,
434: mtl_item_categories mic ,
435: mtl_item_categories mic1 ,
436: mtl_item_categories mic2 ,
437: mtl_categories_b_kfv kfv ,
438: mtl_categories_b_kfv kfv1,
439: mtl_categories_b_kfv kfv2
440: WHERE mtp.organization_id=mti.organization_id

Line 610: mtl_item_categories mic,

606: mti.last_update_date
607: FROM
608: mtl_system_items_b_kfv mti,
609: mtl_parameters mtp,
610: mtl_item_categories mic,
611: mtl_item_categories mic1,
612: mtl_item_categories mic2,
613: mtl_categories_b_kfv kfv,
614: mtl_categories_b_kfv kfv1,

Line 611: mtl_item_categories mic1,

607: FROM
608: mtl_system_items_b_kfv mti,
609: mtl_parameters mtp,
610: mtl_item_categories mic,
611: mtl_item_categories mic1,
612: mtl_item_categories mic2,
613: mtl_categories_b_kfv kfv,
614: mtl_categories_b_kfv kfv1,
615: mtl_categories_b_kfv kfv2

Line 612: mtl_item_categories mic2,

608: mtl_system_items_b_kfv mti,
609: mtl_parameters mtp,
610: mtl_item_categories mic,
611: mtl_item_categories mic1,
612: mtl_item_categories mic2,
613: mtl_categories_b_kfv kfv,
614: mtl_categories_b_kfv kfv1,
615: mtl_categories_b_kfv kfv2
616: WHERE

Line 1382: -- Maintains STAR table when changes are detected on MTL_ITEM_CATEGORIES

1378: END Update_Categories;
1379:
1380:
1381: --**********************************************************************
1382: -- Maintains STAR table when changes are detected on MTL_ITEM_CATEGORIES
1383: --**********************************************************************
1384:
1385: PROCEDURE Sync_Category_Assignments ( p_api_version NUMBER
1386: , p_init_msg_list VARCHAR2 := 'F'

Line 1416: , mtl_item_categories mic

1412: nvl(kfv2.concatenated_segments, 'Unassigned') po_concat_seg,
1413: nvl(mic2.category_Set_id, l_PO_category_set_id) po_category_set_id
1414: FROM
1415: mtl_system_items_b msi
1416: , mtl_item_categories mic
1417: , mtl_categories_b_kfv kfv
1418: , mtl_item_categories mic1
1419: , mtl_categories_b_kfv kfv1
1420: , mtl_item_categories mic2

Line 1418: , mtl_item_categories mic1

1414: FROM
1415: mtl_system_items_b msi
1416: , mtl_item_categories mic
1417: , mtl_categories_b_kfv kfv
1418: , mtl_item_categories mic1
1419: , mtl_categories_b_kfv kfv1
1420: , mtl_item_categories mic2
1421: , mtl_categories_b_kfv kfv2
1422: WHERE

Line 1420: , mtl_item_categories mic2

1416: , mtl_item_categories mic
1417: , mtl_categories_b_kfv kfv
1418: , mtl_item_categories mic1
1419: , mtl_categories_b_kfv kfv1
1420: , mtl_item_categories mic2
1421: , mtl_categories_b_kfv kfv2
1422: WHERE
1423: msi.inventory_item_id = p_inventory_item_id
1424: AND (msi.organization_id = p_organization_id

Line 1688: , mtl_item_categories mic

1684: , item.last_update_date
1685: FROM mtl_system_items_interface interface
1686: , mtl_system_items_b_kfv item
1687: , mtl_parameters mtp
1688: , mtl_item_categories mic
1689: , mtl_categories_b_kfv kfv
1690: , mtl_item_categories mic1
1691: , mtl_categories_b_kfv kfv1
1692: , mtl_item_categories mic2

Line 1690: , mtl_item_categories mic1

1686: , mtl_system_items_b_kfv item
1687: , mtl_parameters mtp
1688: , mtl_item_categories mic
1689: , mtl_categories_b_kfv kfv
1690: , mtl_item_categories mic1
1691: , mtl_categories_b_kfv kfv1
1692: , mtl_item_categories mic2
1693: , mtl_categories_b_kfv kfv2
1694: WHERE item.inventory_item_id = interface.inventory_item_id

Line 1692: , mtl_item_categories mic2

1688: , mtl_item_categories mic
1689: , mtl_categories_b_kfv kfv
1690: , mtl_item_categories mic1
1691: , mtl_categories_b_kfv kfv1
1692: , mtl_item_categories mic2
1693: , mtl_categories_b_kfv kfv2
1694: WHERE item.inventory_item_id = interface.inventory_item_id
1695: AND interface.set_process_id = :p_set_process_id
1696: AND interface.process_flag = 7

Line 1818: , mtl_item_categories mic

1814: , item.last_update_date
1815: FROM mtl_system_items_interface interface
1816: , mtl_system_items_b_kfv item
1817: , mtl_parameters mtp
1818: , mtl_item_categories mic
1819: , mtl_categories_b_kfv kfv
1820: , mtl_item_categories mic1
1821: , mtl_categories_b_kfv kfv1
1822: , mtl_item_categories mic2

Line 1820: , mtl_item_categories mic1

1816: , mtl_system_items_b_kfv item
1817: , mtl_parameters mtp
1818: , mtl_item_categories mic
1819: , mtl_categories_b_kfv kfv
1820: , mtl_item_categories mic1
1821: , mtl_categories_b_kfv kfv1
1822: , mtl_item_categories mic2
1823: , mtl_categories_b_kfv kfv2
1824: WHERE item.inventory_item_id = interface.inventory_item_id

Line 1822: , mtl_item_categories mic2

1818: , mtl_item_categories mic
1819: , mtl_categories_b_kfv kfv
1820: , mtl_item_categories mic1
1821: , mtl_categories_b_kfv kfv1
1822: , mtl_item_categories mic2
1823: , mtl_categories_b_kfv kfv2
1824: WHERE item.inventory_item_id = interface.inventory_item_id
1825: AND interface.set_process_id =
1826: :p_set_process_id

Line 1936: FROM mtl_item_categories C

1932: AND b.child_id = (SELECT DEFAULT_CATEGORY_ID
1933: FROM mtl_category_sets_b
1934: WHERE category_set_id=l_vbh_category_set)
1935: AND EXISTS (SELECT NULL
1936: FROM mtl_item_categories C
1937: WHERE c.category_set_id = l_vbh_category_set
1938: AND c.category_id = b.child_id);
1939:
1940: /** Bug: 4917496

Line 1960: FROM mtl_item_categories C

1956: AND b.object_id = l_vbh_category_set
1957: AND b.item_assgn_flag = 'Y'
1958: AND b.child_id <> -1
1959: AND NOT EXISTS (SELECT NULL
1960: FROM mtl_item_categories C
1961: WHERE c.category_set_id = l_vbh_category_set
1962: AND c.category_id = b.child_id);
1963: **/
1964: -- Checking Item assignment flag for Unassigned category

Line 1983: AND NOT EXISTS (SELECT NULL FROM mtl_item_categories C

1979: we can rely on ENI_OLTP_ITEM_STAR_TABLE to get this info.
1980: SELECT 1 INTO l_count
1981: FROM mtl_system_items_b IT
1982: WHERE ROWNUM = 1
1983: AND NOT EXISTS (SELECT NULL FROM mtl_item_categories C
1984: WHERE c.category_set_id = l_vbh_category_set
1985: AND c.inventory_item_id = it.inventory_item_id
1986: AND c.organization_id = it.organization_id);
1987: */

Line 2050: FROM mtl_item_categories_interface mici

2046:
2047: CURSOR icoi_csr (p_set_process_id NUMBER) IS
2048: SELECT mici.inventory_item_id
2049: ,mp.organization_id
2050: FROM mtl_item_categories_interface mici
2051: ,mtl_parameters mp
2052: WHERE mici.set_process_id = p_set_process_id
2053: AND mici.request_id = l_conc_request_id
2054: AND mici.process_flag = l_process_flag

Line 2117: , mtl_item_categories mic

2113: ,nvl(kfv2.concatenated_segments, 'Unassigned') po_concat_seg
2114: ,nvl(mic2.category_Set_id, l_PO_category_set_id) po_category_set_id
2115: FROM
2116: mtl_system_items_b msi
2117: , mtl_item_categories mic
2118: , mtl_categories_b_kfv kfv
2119: , mtl_item_categories mic1
2120: , mtl_categories_b_kfv kfv1
2121: , mtl_item_categories mic2

Line 2119: , mtl_item_categories mic1

2115: FROM
2116: mtl_system_items_b msi
2117: , mtl_item_categories mic
2118: , mtl_categories_b_kfv kfv
2119: , mtl_item_categories mic1
2120: , mtl_categories_b_kfv kfv1
2121: , mtl_item_categories mic2
2122: , mtl_categories_b_kfv kfv2
2123: WHERE

Line 2121: , mtl_item_categories mic2

2117: , mtl_item_categories mic
2118: , mtl_categories_b_kfv kfv
2119: , mtl_item_categories mic1
2120: , mtl_categories_b_kfv kfv1
2121: , mtl_item_categories mic2
2122: , mtl_categories_b_kfv kfv2
2123: WHERE
2124: msi.inventory_item_id = star.inventory_item_id
2125: AND msi.organization_id = star.organization_id

Line 2150: FROM mtl_item_categories_interface

2146:
2147: -- updating Item Assignment flag for all categories,
2148: -- which have items attached to it
2149: FOR intf_categories_add IN (SELECT DISTINCT CATEGORY_ID
2150: FROM mtl_item_categories_interface
2151: WHERE process_flag = 7
2152: AND transaction_type IN ('CREATE','UPDATE')
2153: AND set_process_id = p_set_process_id
2154: AND category_set_id = l_vbh_category_set_id)

Line 2171: FROM mtl_item_categories C

2167: AND b.object_id = l_vbh_category_set_id
2168: AND b.item_assgn_flag = 'N'
2169: AND b.child_id = intf_categories_add.category_id
2170: AND EXISTS (SELECT NULL
2171: FROM mtl_item_categories C
2172: WHERE c.category_set_id = l_vbh_category_set_id
2173: AND c.category_id = b.child_id);
2174:
2175: l_num_updates := l_num_updates + SQL%ROWCOUNT;

Line 2184: FROM mtl_item_categories_interface

2180: (SELECT DISTINCT
2181: Decode(TRANSACTION_TYPE,
2182: 'UPDATE',OLD_CATEGORY_ID,
2183: CATEGORY_ID) AS CATEGORY_ID
2184: FROM mtl_item_categories_interface
2185: WHERE process_flag = 7
2186: AND TRANSACTION_TYPE IN ('DELETE','UPDATE')
2187: AND set_process_id = p_set_process_id
2188: AND category_set_id = l_vbh_category_set_id)

Line 2206: FROM mtl_item_categories C

2202: AND b.object_id = l_vbh_category_set_id
2203: AND b.item_assgn_flag = 'Y'
2204: AND b.child_id = intf_categories_del.category_id
2205: AND NOT EXISTS (SELECT NULL
2206: FROM mtl_item_categories C
2207: WHERE c.category_set_id = l_vbh_category_set_id
2208: AND c.category_id = b.child_id);
2209:
2210: l_num_updates := l_num_updates + SQL%ROWCOUNT;

Line 2238: AND NOT EXISTS (SELECT NULL FROM mtl_item_categories C

2234: we can rely on ENI_OLTP_ITEM_STAR_TABLE to get this info.
2235: SELECT 1 INTO l_count
2236: FROM mtl_system_items_b IT
2237: WHERE ROWNUM = 1
2238: AND NOT EXISTS (SELECT NULL FROM mtl_item_categories C
2239: WHERE c.category_set_id = l_vbh_category_set_id
2240: AND c.inventory_item_id = it.inventory_item_id
2241: AND c.organization_id = it.organization_id);
2242: */