[Home] [Help]
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 ,
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,
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;
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
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;
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;
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:
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;
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;
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
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
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;