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_CATEGORIES_B_KFV

Line 437: mtl_categories_b_kfv kfv ,

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
441: AND mic.organization_id(+) = mti.organization_id

Line 438: mtl_categories_b_kfv kfv1,

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
441: AND mic.organization_id(+) = mti.organization_id
442: AND mic.inventory_item_id(+) = mti.inventory_item_id

Line 439: mtl_categories_b_kfv kfv2

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
441: AND mic.organization_id(+) = mti.organization_id
442: AND mic.inventory_item_id(+) = mti.inventory_item_id
443: AND mic.category_id = kfv.category_id (+)

Line 613: mtl_categories_b_kfv kfv,

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
617: mtp.organization_id = mti.organization_id AND

Line 614: mtl_categories_b_kfv kfv1,

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
617: mtp.organization_id = mti.organization_id AND
618: mic.organization_id(+) = mti.organization_id AND

Line 615: mtl_categories_b_kfv kfv2

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
617: mtp.organization_id = mti.organization_id AND
618: mic.organization_id(+) = mti.organization_id AND
619: mic.inventory_item_id(+) = mti.inventory_item_id AND

Line 1355: from mtl_categories_b_kfv

1351: THEN
1352: UPDATE ENI_OLTP_ITEM_STAR
1353: SET VBH_CONCAT_SEG =
1354: (select concatenated_segments
1355: from mtl_categories_b_kfv
1356: where category_id = p_category_id)
1357: WHERE vbh_category_id = p_category_id;
1358: ELSIF which_category_set = 'INV_CATEGORY'
1359: THEN

Line 1363: from mtl_categories_b_kfv

1359: THEN
1360: UPDATE ENI_OLTP_ITEM_STAR
1361: SET INV_CONCAT_SEG =
1362: (select concatenated_segments
1363: from mtl_categories_b_kfv
1364: where category_id = p_category_id)
1365: WHERE inv_category_id = p_category_id;
1366: END IF;
1367:

Line 1417: , mtl_categories_b_kfv kfv

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
1421: , mtl_categories_b_kfv kfv2

Line 1419: , mtl_categories_b_kfv kfv1

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
1423: msi.inventory_item_id = p_inventory_item_id

Line 1421: , mtl_categories_b_kfv kfv2

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
1425: or msi.organization_id in (SELECT mp.organization_id

Line 1689: , mtl_categories_b_kfv kfv

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
1693: , mtl_categories_b_kfv kfv2

Line 1691: , mtl_categories_b_kfv kfv1

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
1695: AND interface.set_process_id = :p_set_process_id

Line 1693: , mtl_categories_b_kfv kfv2

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
1697: AND item.organization_id = interface.organization_id

Line 1819: , mtl_categories_b_kfv kfv

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
1823: , mtl_categories_b_kfv kfv2

Line 1821: , mtl_categories_b_kfv kfv1

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
1825: AND interface.set_process_id =

Line 1823: , mtl_categories_b_kfv kfv2

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
1827: AND interface.process_flag = 7

Line 2118: , mtl_categories_b_kfv kfv

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
2122: , mtl_categories_b_kfv kfv2

Line 2120: , mtl_categories_b_kfv kfv1

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
2124: msi.inventory_item_id = star.inventory_item_id

Line 2122: , mtl_categories_b_kfv kfv2

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
2126: AND mic.inventory_item_id (+) = msi.inventory_item_id