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_SYSTEM_ITEMS_B

Line 423: FROM mtl_system_items_b_kfv mti,

419: mti.unit_volume,
420: mti.weight_uom_code,
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 ,

Line 599: mtl_system_items_b_kfv mti,

595: mti.eam_item_type,
596: mti.creation_date,
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,

Line 701: FUNCTION Get_Item_Number(P_Inventory_Item_Id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE

697: -- Maintain STAR table when changes are detected on MTL_SYSTEM_ITEMS
698: --**********************************************************************
699:
700: --Start :5688257 : %Items_In_Star functions to use flex API's to get concatenated segments
701: FUNCTION Get_Item_Number(P_Inventory_Item_Id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
702: ,P_Organization_Id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)
703: RETURN VARCHAR2 IS
704: l_delimiter VARCHAR2(10);
705: l_segs FND_FLEX_EXT.SegmentArray;

Line 702: ,P_Organization_Id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)

698: --**********************************************************************
699:
700: --Start :5688257 : %Items_In_Star functions to use flex API's to get concatenated segments
701: FUNCTION Get_Item_Number(P_Inventory_Item_Id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
702: ,P_Organization_Id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)
703: RETURN VARCHAR2 IS
704: l_delimiter VARCHAR2(10);
705: l_segs FND_FLEX_EXT.SegmentArray;
706: l_n_segs NUMBER;

Line 844: FROM mtl_system_items_b_kfv mti,

840: l_vbh_category_set,
841: 'Unassigned',
842: mti.creation_date,
843: mti.last_update_date
844: FROM mtl_system_items_b_kfv mti,
845: mtl_parameters mtp
846: WHERE mti.inventory_item_id = p_inventory_item_id
847: AND mti.organization_id = p_organization_id
848: AND mti.organization_id= mtp.organization_id;

Line 920: FROM mtl_system_items_b_kfv mti

916: ,mti.unit_volume
917: ,mti.weight_uom_code
918: ,mti.volume_uom_code
919: ,mti.eam_item_type
920: FROM mtl_system_items_b_kfv mti
921: , mtl_parameters b
922: WHERE mti.inventory_item_id = p_inventory_item_id
923: AND mti.organization_id = b.organization_id
924: AND b.master_organization_id = p_organization_id;

Line 936: FROM mtl_system_items_b mti

932: , mti.volume_uom_code
933: , primary_uom_code
934: , eam_item_type
935: , mti.last_update_date
936: FROM mtl_system_items_b mti
937: WHERE mti.inventory_item_id = p_inventory_item_id
938: AND mti.organization_id = p_organization_id;
939:
940: isMasterOrg NUMBER;

Line 1235: mtl_system_items_b msi

1231: nvl(mic2.category_id, -1) po_category_id,
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

Line 1504: , mtl_system_items_b_kfv item

1500: , item.eam_item_type
1501: , item.creation_date
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

Line 1632: , mtl_system_items_b_kfv item

1628: , item.eam_item_type
1629: , item.creation_date
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

Line 1797: FROM mtl_system_items_b IT

1793: Replaced with the SQL above
1794: As UNASSIGNED category is only used by DBI
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

Line 1932: mtl_system_items_b msi

1928: ,nvl(mic2.category_id, -1) po_category_id
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

Line 2052: FROM mtl_system_items_b IT

2048: Replaced with the SQL above
2049: As UNASSIGNED category is only used by DBI
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

Line 2096: FROM MTL_SYSTEM_ITEMS_B_KFV

2092:
2093: --Start :5688257 : %Items_In_Star functions to use flex API's to get concatenated segments
2094: BEGIN
2095: SELECT NVL(LENGTH(CONCATENATED_SEGMENTS),0) INTO G_INSTALL_PHASE
2096: FROM MTL_SYSTEM_ITEMS_B_KFV
2097: WHERE ROWNUM = 1;
2098: EXCEPTION
2099: WHEN OTHERS THEN
2100: G_INSTALL_PHASE := 0;