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 425: mtl_item_categories mic ,

421: mti.volume_uom_code,
422: mti.eam_item_type
423: FROM mtl_system_items_b_kfv mti,
424: mtl_parameters mtp,
425: mtl_item_categories mic ,
426: mtl_item_categories mic1 ,
427: mtl_item_categories mic2 ,
428: mtl_categories_b_kfv kfv ,
429: mtl_categories_b_kfv kfv1,

Line 426: mtl_item_categories mic1 ,

422: mti.eam_item_type
423: FROM mtl_system_items_b_kfv mti,
424: mtl_parameters mtp,
425: mtl_item_categories mic ,
426: mtl_item_categories mic1 ,
427: mtl_item_categories mic2 ,
428: mtl_categories_b_kfv kfv ,
429: mtl_categories_b_kfv kfv1,
430: mtl_categories_b_kfv kfv2

Line 427: mtl_item_categories mic2 ,

423: FROM mtl_system_items_b_kfv mti,
424: mtl_parameters mtp,
425: mtl_item_categories mic ,
426: mtl_item_categories mic1 ,
427: mtl_item_categories mic2 ,
428: mtl_categories_b_kfv kfv ,
429: mtl_categories_b_kfv kfv1,
430: mtl_categories_b_kfv kfv2
431: WHERE mtp.organization_id=mti.organization_id

Line 601: mtl_item_categories mic,

597: mti.last_update_date
598: FROM
599: mtl_system_items_b_kfv mti,
600: mtl_parameters mtp,
601: mtl_item_categories mic,
602: mtl_item_categories mic1,
603: mtl_item_categories mic2,
604: mtl_categories_b_kfv kfv,
605: mtl_categories_b_kfv kfv1,

Line 602: mtl_item_categories mic1,

598: FROM
599: mtl_system_items_b_kfv mti,
600: mtl_parameters mtp,
601: mtl_item_categories mic,
602: mtl_item_categories mic1,
603: mtl_item_categories mic2,
604: mtl_categories_b_kfv kfv,
605: mtl_categories_b_kfv kfv1,
606: mtl_categories_b_kfv kfv2

Line 603: mtl_item_categories mic2,

599: mtl_system_items_b_kfv mti,
600: mtl_parameters mtp,
601: mtl_item_categories mic,
602: mtl_item_categories mic1,
603: mtl_item_categories mic2,
604: mtl_categories_b_kfv kfv,
605: mtl_categories_b_kfv kfv1,
606: mtl_categories_b_kfv kfv2
607: WHERE

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

1198: END Update_Categories;
1199:
1200:
1201: --**********************************************************************
1202: -- Maintains STAR table when changes are detected on MTL_ITEM_CATEGORIES
1203: --**********************************************************************
1204:
1205: PROCEDURE Sync_Category_Assignments ( p_api_version NUMBER
1206: , p_init_msg_list VARCHAR2 := 'F'

Line 1236: , mtl_item_categories mic

1232: nvl(kfv2.concatenated_segments, 'Unassigned') po_concat_seg,
1233: nvl(mic2.category_Set_id, l_PO_category_set_id) po_category_set_id
1234: FROM
1235: mtl_system_items_b msi
1236: , mtl_item_categories mic
1237: , mtl_categories_b_kfv kfv
1238: , mtl_item_categories mic1
1239: , mtl_categories_b_kfv kfv1
1240: , mtl_item_categories mic2

Line 1238: , mtl_item_categories mic1

1234: FROM
1235: mtl_system_items_b msi
1236: , mtl_item_categories mic
1237: , mtl_categories_b_kfv kfv
1238: , mtl_item_categories mic1
1239: , mtl_categories_b_kfv kfv1
1240: , mtl_item_categories mic2
1241: , mtl_categories_b_kfv kfv2
1242: WHERE

Line 1240: , mtl_item_categories mic2

1236: , mtl_item_categories mic
1237: , mtl_categories_b_kfv kfv
1238: , mtl_item_categories mic1
1239: , mtl_categories_b_kfv kfv1
1240: , mtl_item_categories mic2
1241: , mtl_categories_b_kfv kfv2
1242: WHERE
1243: msi.inventory_item_id = p_inventory_item_id
1244: AND (msi.organization_id = p_organization_id

Line 1506: , mtl_item_categories mic

1502: , item.last_update_date
1503: FROM mtl_system_items_interface interface
1504: , mtl_system_items_b_kfv item
1505: , mtl_parameters mtp
1506: , mtl_item_categories mic
1507: , mtl_categories_b_kfv kfv
1508: , mtl_item_categories mic1
1509: , mtl_categories_b_kfv kfv1
1510: , mtl_item_categories mic2

Line 1508: , mtl_item_categories mic1

1504: , mtl_system_items_b_kfv item
1505: , mtl_parameters mtp
1506: , mtl_item_categories mic
1507: , mtl_categories_b_kfv kfv
1508: , mtl_item_categories mic1
1509: , mtl_categories_b_kfv kfv1
1510: , mtl_item_categories mic2
1511: , mtl_categories_b_kfv kfv2
1512: WHERE item.inventory_item_id = interface.inventory_item_id

Line 1510: , mtl_item_categories mic2

1506: , mtl_item_categories mic
1507: , mtl_categories_b_kfv kfv
1508: , mtl_item_categories mic1
1509: , mtl_categories_b_kfv kfv1
1510: , mtl_item_categories mic2
1511: , mtl_categories_b_kfv kfv2
1512: WHERE item.inventory_item_id = interface.inventory_item_id
1513: AND interface.set_process_id = :p_set_process_id
1514: AND interface.process_flag = 7

Line 1634: , mtl_item_categories mic

1630: , item.last_update_date
1631: FROM mtl_system_items_interface interface
1632: , mtl_system_items_b_kfv item
1633: , mtl_parameters mtp
1634: , mtl_item_categories mic
1635: , mtl_categories_b_kfv kfv
1636: , mtl_item_categories mic1
1637: , mtl_categories_b_kfv kfv1
1638: , mtl_item_categories mic2

Line 1636: , mtl_item_categories mic1

1632: , mtl_system_items_b_kfv item
1633: , mtl_parameters mtp
1634: , mtl_item_categories mic
1635: , mtl_categories_b_kfv kfv
1636: , mtl_item_categories mic1
1637: , mtl_categories_b_kfv kfv1
1638: , mtl_item_categories mic2
1639: , mtl_categories_b_kfv kfv2
1640: WHERE item.inventory_item_id = interface.inventory_item_id

Line 1638: , mtl_item_categories mic2

1634: , mtl_item_categories mic
1635: , mtl_categories_b_kfv kfv
1636: , mtl_item_categories mic1
1637: , mtl_categories_b_kfv kfv1
1638: , mtl_item_categories mic2
1639: , mtl_categories_b_kfv kfv2
1640: WHERE item.inventory_item_id = interface.inventory_item_id
1641: AND interface.set_process_id =
1642: :p_set_process_id

Line 1752: FROM mtl_item_categories C

1748: AND b.child_id = (SELECT DEFAULT_CATEGORY_ID
1749: FROM mtl_category_sets_b
1750: WHERE category_set_id=l_vbh_category_set)
1751: AND EXISTS (SELECT NULL
1752: FROM mtl_item_categories C
1753: WHERE c.category_set_id = l_vbh_category_set
1754: AND c.category_id = b.child_id);
1755:
1756: /** Bug: 4917496

Line 1776: FROM mtl_item_categories C

1772: AND b.object_id = l_vbh_category_set
1773: AND b.item_assgn_flag = 'Y'
1774: AND b.child_id <> -1
1775: AND NOT EXISTS (SELECT NULL
1776: FROM mtl_item_categories C
1777: WHERE c.category_set_id = l_vbh_category_set
1778: AND c.category_id = b.child_id);
1779: **/
1780: -- Checking Item assignment flag for Unassigned category

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

1795: we can rely on ENI_OLTP_ITEM_STAR_TABLE to get this info.
1796: SELECT 1 INTO l_count
1797: FROM mtl_system_items_b IT
1798: WHERE ROWNUM = 1
1799: AND NOT EXISTS (SELECT NULL FROM mtl_item_categories C
1800: WHERE c.category_set_id = l_vbh_category_set
1801: AND c.inventory_item_id = it.inventory_item_id
1802: AND c.organization_id = it.organization_id);
1803: */

Line 1866: FROM mtl_item_categories_interface mici

1862:
1863: CURSOR icoi_csr (p_set_process_id NUMBER) IS
1864: SELECT mici.inventory_item_id
1865: ,mp.organization_id
1866: FROM mtl_item_categories_interface mici
1867: ,mtl_parameters mp
1868: WHERE mici.set_process_id = p_set_process_id
1869: AND mici.request_id = l_conc_request_id
1870: AND mici.process_flag = l_process_flag

Line 1933: , mtl_item_categories mic

1929: ,nvl(kfv2.concatenated_segments, 'Unassigned') po_concat_seg
1930: ,nvl(mic2.category_Set_id, l_PO_category_set_id) po_category_set_id
1931: FROM
1932: mtl_system_items_b msi
1933: , mtl_item_categories mic
1934: , mtl_categories_b_kfv kfv
1935: , mtl_item_categories mic1
1936: , mtl_categories_b_kfv kfv1
1937: , mtl_item_categories mic2

Line 1935: , mtl_item_categories mic1

1931: FROM
1932: mtl_system_items_b msi
1933: , mtl_item_categories mic
1934: , mtl_categories_b_kfv kfv
1935: , mtl_item_categories mic1
1936: , mtl_categories_b_kfv kfv1
1937: , mtl_item_categories mic2
1938: , mtl_categories_b_kfv kfv2
1939: WHERE

Line 1937: , mtl_item_categories mic2

1933: , mtl_item_categories mic
1934: , mtl_categories_b_kfv kfv
1935: , mtl_item_categories mic1
1936: , mtl_categories_b_kfv kfv1
1937: , mtl_item_categories mic2
1938: , mtl_categories_b_kfv kfv2
1939: WHERE
1940: msi.inventory_item_id = star.inventory_item_id
1941: AND msi.organization_id = star.organization_id

Line 1966: FROM mtl_item_categories_interface

1962:
1963: -- updating Item Assignment flag for all categories,
1964: -- which have items attached to it
1965: FOR intf_categories_add IN (SELECT DISTINCT CATEGORY_ID
1966: FROM mtl_item_categories_interface
1967: WHERE process_flag = 7
1968: AND transaction_type IN ('CREATE','UPDATE')
1969: AND set_process_id = p_set_process_id
1970: AND category_set_id = l_vbh_category_set_id)

Line 1987: FROM mtl_item_categories C

1983: AND b.object_id = l_vbh_category_set_id
1984: AND b.item_assgn_flag = 'N'
1985: AND b.child_id = intf_categories_add.category_id
1986: AND EXISTS (SELECT NULL
1987: FROM mtl_item_categories C
1988: WHERE c.category_set_id = l_vbh_category_set_id
1989: AND c.category_id = b.child_id);
1990:
1991: l_num_updates := l_num_updates + SQL%ROWCOUNT;

Line 2000: FROM mtl_item_categories_interface

1996: (SELECT DISTINCT
1997: Decode(TRANSACTION_TYPE,
1998: 'UPDATE',OLD_CATEGORY_ID,
1999: CATEGORY_ID) AS CATEGORY_ID
2000: FROM mtl_item_categories_interface
2001: WHERE process_flag = 7
2002: AND TRANSACTION_TYPE IN ('DELETE','UPDATE')
2003: AND set_process_id = p_set_process_id
2004: AND category_set_id = l_vbh_category_set_id)

Line 2022: FROM mtl_item_categories C

2018: AND b.object_id = l_vbh_category_set_id
2019: AND b.item_assgn_flag = 'Y'
2020: AND b.child_id = intf_categories_del.category_id
2021: AND NOT EXISTS (SELECT NULL
2022: FROM mtl_item_categories C
2023: WHERE c.category_set_id = l_vbh_category_set_id
2024: AND c.category_id = b.child_id);
2025:
2026: l_num_updates := l_num_updates + SQL%ROWCOUNT;

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

2050: we can rely on ENI_OLTP_ITEM_STAR_TABLE to get this info.
2051: SELECT 1 INTO l_count
2052: FROM mtl_system_items_b IT
2053: WHERE ROWNUM = 1
2054: AND NOT EXISTS (SELECT NULL FROM mtl_item_categories C
2055: WHERE c.category_set_id = l_vbh_category_set_id
2056: AND c.inventory_item_id = it.inventory_item_id
2057: AND c.organization_id = it.organization_id);
2058: */