APPS.EAM_ASSET_MOVE_PUB dependencies on MTL_SYSTEM_ITEMS

Line 251: mtl_system_items_b msi ,

247: msi.eam_item_type ,
248: mp.MAINT_ORGANIZATION_ID
249: FROM mtl_serial_numbers msn ,
250: mtl_object_genealogy mog,
251: mtl_system_items_b msi ,
252: csi_item_instances cii ,
253: mtl_parameters mp
254: WHERE mog.object_id = msn.gen_object_id
255: AND msn.current_organization_id = msi.organization_id

Line 328: MTL_SYSTEM_ITEMS_B msi

324: INTO l_parent_inf_rec
325: FROM CSI_ITEM_INSTANCES cii,
326: MTL_PARAMETERS mp ,
327: MTL_SERIAL_NUMBERS msn,
328: MTL_SYSTEM_ITEMS_B msi
329: WHERE cii.instance_id =p_parent_instance_id
330: AND cii.SERIAL_NUMBER = msn.SERIAL_NUMBER
331: AND mp.organization_id =cii.last_vld_organization_id
332: AND msn.current_organization_id = msi.organization_id

Line 552: l_Transaction_UOM mtl_system_items_b_kfv.primary_uom_code%type;

548: IS
549: l_EAM_ASSET_MOVE_REC EAM_ASSET_MOVE_TEMP%ROWTYPE ;
550: l_txn_if_id NUMBER;
551: l_SERIAL_NUMBER VARCHAR2(30);
552: l_Transaction_UOM mtl_system_items_b_kfv.primary_uom_code%type;
553: l_serial_number_control_code mtl_system_items_b_kfv.serial_number_control_code%TYPE;
554: l_Item_Revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE;
555: l_Transaction_Quantity NUMBER;
556: x_Message VARCHAR2(240);

Line 553: l_serial_number_control_code mtl_system_items_b_kfv.serial_number_control_code%TYPE;

549: l_EAM_ASSET_MOVE_REC EAM_ASSET_MOVE_TEMP%ROWTYPE ;
550: l_txn_if_id NUMBER;
551: l_SERIAL_NUMBER VARCHAR2(30);
552: l_Transaction_UOM mtl_system_items_b_kfv.primary_uom_code%type;
553: l_serial_number_control_code mtl_system_items_b_kfv.serial_number_control_code%TYPE;
554: l_Item_Revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE;
555: l_Transaction_Quantity NUMBER;
556: x_Message VARCHAR2(240);
557: x_Status VARCHAR2(30);

Line 790: FROM mtl_system_items_b

786: LOT_CONTROL_CODE
787: INTO l_Transaction_UOM ,
788: l_serial_number_control_code,
789: l_lot_control_code
790: FROM mtl_system_items_b
791: WHERE inventory_item_id=p_inventory_item_id
792: AND organization_id =p_CURRENT_ORGANIZATION_ID;
793:
794: EXCEPTION

Line 1162: FROM MTL_SYSTEM_ITEMS

1158: Begin
1159: SELECT
1160: location_control_code,restrict_locators_code into
1161: x_item_ctrl,x_restrict_flag
1162: FROM MTL_SYSTEM_ITEMS
1163: WHERE
1164: inventory_item_id = p_item_id and
1165: organization_id = p_org;
1166: Exception

Line 1321: FROM mtl_system_items_b

1317: BEGIN
1318:
1319: SELECT primary_uom_code
1320: INTO l_uom
1321: FROM mtl_system_items_b
1322: WHERE inventory_item_id=p_inventory_item_id
1323: AND organization_id =p_CURRENT_ORGANIZATION_ID;
1324: EXCEPTION
1325: When no_data_found then

Line 1482: FROM mtl_system_items_b

1478:
1479: /*
1480: SELECT primary_uom_code
1481: INTO l_uom
1482: FROM mtl_system_items_b
1483: WHERE inventory_item_id=p_inventory_item_id
1484: AND organization_id =p_ORGANIZATION_ID;
1485:
1486: SELECT ACCT_PERIOD_ID