APPS.EAM_ASSET_MOVE_PUB dependencies on MTL_SYSTEM_ITEMS

Line 243: mtl_system_items_b msi ,

239: msi.eam_item_type ,
240: mp.MAINT_ORGANIZATION_ID
241: FROM mtl_serial_numbers msn ,
242: mtl_object_genealogy mog,
243: mtl_system_items_b msi ,
244: csi_item_instances cii ,
245: mtl_parameters mp
246: WHERE mog.object_id = msn.gen_object_id
247: AND msn.current_organization_id = msi.organization_id

Line 315: MTL_SYSTEM_ITEMS_B msi

311: INTO l_parent_inf_rec
312: FROM CSI_ITEM_INSTANCES cii,
313: MTL_PARAMETERS mp ,
314: MTL_SERIAL_NUMBERS msn,
315: MTL_SYSTEM_ITEMS_B msi
316: WHERE cii.instance_id =p_parent_instance_id
317: AND cii.SERIAL_NUMBER = msn.SERIAL_NUMBER
318: AND mp.organization_id =cii.last_vld_organization_id
319: AND msn.current_organization_id = msi.organization_id

Line 538: l_Transaction_UOM mtl_system_items_b_kfv.primary_uom_code%type;

534: IS
535: l_EAM_ASSET_MOVE_REC EAM_ASSET_MOVE_TEMP%ROWTYPE ;
536: l_txn_if_id NUMBER;
537: l_SERIAL_NUMBER VARCHAR2(30);
538: l_Transaction_UOM mtl_system_items_b_kfv.primary_uom_code%type;
539: l_serial_number_control_code mtl_system_items_b_kfv.serial_number_control_code%TYPE;
540: l_Item_Revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE;
541: l_Transaction_Quantity NUMBER;
542: x_Message VARCHAR2(240);

Line 539: l_serial_number_control_code mtl_system_items_b_kfv.serial_number_control_code%TYPE;

535: l_EAM_ASSET_MOVE_REC EAM_ASSET_MOVE_TEMP%ROWTYPE ;
536: l_txn_if_id NUMBER;
537: l_SERIAL_NUMBER VARCHAR2(30);
538: l_Transaction_UOM mtl_system_items_b_kfv.primary_uom_code%type;
539: l_serial_number_control_code mtl_system_items_b_kfv.serial_number_control_code%TYPE;
540: l_Item_Revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE;
541: l_Transaction_Quantity NUMBER;
542: x_Message VARCHAR2(240);
543: x_Status VARCHAR2(30);

Line 775: FROM mtl_system_items_b

771: LOT_CONTROL_CODE
772: INTO l_Transaction_UOM ,
773: l_serial_number_control_code,
774: l_lot_control_code
775: FROM mtl_system_items_b
776: WHERE inventory_item_id=p_inventory_item_id
777: AND organization_id =p_CURRENT_ORGANIZATION_ID;
778:
779: EXCEPTION

Line 1078: FROM MTL_SYSTEM_ITEMS

1074: Begin
1075: SELECT
1076: location_control_code,restrict_locators_code into
1077: x_item_ctrl,x_restrict_flag
1078: FROM MTL_SYSTEM_ITEMS
1079: WHERE
1080: inventory_item_id = p_item_id and
1081: organization_id = p_org;
1082: Exception