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 428: mtl_categories_b_kfv kfv ,

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

Line 429: mtl_categories_b_kfv kfv1,

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

Line 430: mtl_categories_b_kfv kfv2

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
432: AND mic.organization_id(+) = mti.organization_id
433: AND mic.inventory_item_id(+) = mti.inventory_item_id
434: AND mic.category_id = kfv.category_id (+)

Line 604: mtl_categories_b_kfv kfv,

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

Line 605: mtl_categories_b_kfv kfv1,

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

Line 606: mtl_categories_b_kfv kfv2

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
608: mtp.organization_id = mti.organization_id AND
609: mic.organization_id(+) = mti.organization_id AND
610: mic.inventory_item_id(+) = mti.inventory_item_id AND

Line 1175: from mtl_categories_b_kfv

1171: THEN
1172: UPDATE ENI_OLTP_ITEM_STAR
1173: SET VBH_CONCAT_SEG =
1174: (select concatenated_segments
1175: from mtl_categories_b_kfv
1176: where category_id = p_category_id)
1177: WHERE vbh_category_id = p_category_id;
1178: ELSIF which_category_set = 'INV_CATEGORY'
1179: THEN

Line 1183: from mtl_categories_b_kfv

1179: THEN
1180: UPDATE ENI_OLTP_ITEM_STAR
1181: SET INV_CONCAT_SEG =
1182: (select concatenated_segments
1183: from mtl_categories_b_kfv
1184: where category_id = p_category_id)
1185: WHERE inv_category_id = p_category_id;
1186: END IF;
1187:

Line 1237: , mtl_categories_b_kfv kfv

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

Line 1239: , mtl_categories_b_kfv kfv1

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

Line 1241: , mtl_categories_b_kfv kfv2

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

Line 1507: , mtl_categories_b_kfv kfv

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

Line 1509: , mtl_categories_b_kfv kfv1

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

Line 1511: , mtl_categories_b_kfv kfv2

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

Line 1635: , mtl_categories_b_kfv kfv

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

Line 1637: , mtl_categories_b_kfv kfv1

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

Line 1639: , mtl_categories_b_kfv kfv2

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

Line 1934: , mtl_categories_b_kfv kfv

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

Line 1936: , mtl_categories_b_kfv kfv1

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

Line 1938: , mtl_categories_b_kfv kfv2

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