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 432: FROM mtl_system_items_b_kfv mti,

428: mti.unit_volume,
429: mti.weight_uom_code,
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 ,

Line 608: mtl_system_items_b_kfv mti,

604: mti.eam_item_type,
605: mti.creation_date,
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,

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

706: -- Maintain STAR table when changes are detected on MTL_SYSTEM_ITEMS
707: --**********************************************************************
708:
709: --Start :5688257 : %Items_In_Star functions to use flex API's to get concatenated segments
710: FUNCTION Get_Item_Number(P_Inventory_Item_Id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
711: ,P_Organization_Id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)
712: RETURN VARCHAR2 IS
713: l_delimiter VARCHAR2(10);
714: l_segs FND_FLEX_EXT.SegmentArray;

Line 711: ,P_Organization_Id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)

707: --**********************************************************************
708:
709: --Start :5688257 : %Items_In_Star functions to use flex API's to get concatenated segments
710: FUNCTION Get_Item_Number(P_Inventory_Item_Id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE
711: ,P_Organization_Id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE)
712: RETURN VARCHAR2 IS
713: l_delimiter VARCHAR2(10);
714: l_segs FND_FLEX_EXT.SegmentArray;
715: l_n_segs NUMBER;

Line 853: FROM mtl_system_items_b_kfv mti,

849: l_vbh_category_set,
850: 'Unassigned',
851: mti.creation_date,
852: mti.last_update_date
853: FROM mtl_system_items_b_kfv mti,
854: mtl_parameters mtp
855: WHERE mti.inventory_item_id = p_inventory_item_id
856: AND mti.organization_id = p_organization_id
857: AND mti.organization_id= mtp.organization_id;

Line 906: l_pres_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;

902: ,p_organization_id NUMBER)
903: RETURN BOOLEAN
904: IS
905: l_prev_item_number eni_oltp_item_star.Value%TYPE;
906: l_pres_item_number mtl_system_items_b_kfv.concatenated_segments%TYPE;
907:
908: BEGIN
909:
910: BEGIN

Line 912: FROM mtl_system_items_b_kfv msik,

908: BEGIN
909:
910: BEGIN
911: SELECT msik.concatenated_segments || ' (' || mp.organization_code || ')' Value INTO l_pres_item_number
912: FROM mtl_system_items_b_kfv msik,
913: mtl_parameters mp
914: WHERE msik.inventory_item_id=p_inventory_item_id
915: AND msik.organization_id=mp.organization_id
916: AND mp.organization_id=p_organization_id;

Line 919: /* If mtl_system_items_b_kfv is not generated properly there could be a chance of exception here*/

915: AND msik.organization_id=mp.organization_id
916: AND mp.organization_id=p_organization_id;
917: EXCEPTION
918: WHEN Others THEN
919: /* If mtl_system_items_b_kfv is not generated properly there could be a chance of exception here*/
920: /* log error raised here */
921: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
922: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'IS_ITEM_NUMBER_CHANGED', SQLERRM);
923: END IF;

Line 936: It is safe to update table ENI_OLTP_ITEM_STAR with values from MTL_SYSTEM_ITEMS_B_KFV

932:
933: EXCEPTION
934: WHEN No_Data_Found THEN
935: /*It means there is no data exists in ENI_OLTP_ITEM_STAR, may be load truncated the table
936: It is safe to update table ENI_OLTP_ITEM_STAR with values from MTL_SYSTEM_ITEMS_B_KFV
937: */
938: RETURN TRUE ;
939: END;
940:

Line 971: FROM mtl_system_items_b_kfv mti

967: ,mti.unit_weight
968: ,mti.unit_volume
969: ,mti.weight_uom_code
970: ,mti.volume_uom_code
971: FROM mtl_system_items_b_kfv mti
972: , mtl_parameters b
973: WHERE mti.inventory_item_id = p_inventory_item_id
974: AND mti.organization_id = b.organization_id
975: AND b.master_organization_id <> p_organization_id;

Line 1080: FROM mtl_system_items_b_kfv mti

1076: ,mti.unit_volume
1077: ,mti.weight_uom_code
1078: ,mti.volume_uom_code
1079: ,mti.eam_item_type
1080: FROM mtl_system_items_b_kfv mti
1081: , mtl_parameters b
1082: WHERE mti.inventory_item_id = p_inventory_item_id
1083: AND mti.organization_id = b.organization_id
1084: AND b.master_organization_id = p_organization_id;

Line 1096: FROM mtl_system_items_b mti

1092: , mti.volume_uom_code
1093: , primary_uom_code
1094: , eam_item_type
1095: , mti.last_update_date
1096: FROM mtl_system_items_b mti
1097: WHERE mti.inventory_item_id = p_inventory_item_id
1098: AND mti.organization_id = p_organization_id;
1099:
1100: isMasterOrg NUMBER;

Line 1415: mtl_system_items_b msi

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

Line 1686: , mtl_system_items_b_kfv item

1682: , item.eam_item_type
1683: , item.creation_date
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

Line 1816: , mtl_system_items_b_kfv item

1812: , item.eam_item_type
1813: , item.creation_date
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

Line 1981: FROM mtl_system_items_b IT

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

Line 2116: mtl_system_items_b msi

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

Line 2236: FROM mtl_system_items_b IT

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

Line 2280: FROM MTL_SYSTEM_ITEMS_B_KFV

2276:
2277: --Start :5688257 : %Items_In_Star functions to use flex API's to get concatenated segments
2278: BEGIN
2279: SELECT NVL(LENGTH(CONCATENATED_SEGMENTS),0) INTO G_INSTALL_PHASE
2280: FROM MTL_SYSTEM_ITEMS_B_KFV
2281: WHERE ROWNUM = 1;
2282: EXCEPTION
2283: WHEN OTHERS THEN
2284: G_INSTALL_PHASE := 0;